QA_INSPECTION_PLANS_VL

Details

• Schema: FUSION

• Object owner: QA

• Object type: VIEW

Columns

Name

INSPECTION_PLAN_ID ASSET_ID ASSET_GROUP_ID OBJECT_VERSION_NUMBER ORGANIZATION_ID INSPECTION_PLAN_CODE VERSION_NUMBER NAME DESCRIPTION INSPECTION_PLAN_TYPE INSPECTION_PLAN_STATUS ENABLED_FLAG EFFECTIVE_START_DATE EFFECTIVE_END_DATE INSPECTION_LEVEL_ID INVENTORY_ITEM_ID REVISION REVISION_ID CATEGORY_SET_ID CATEGORY_ID WORK_CENTER_ID RESOURCE_ID OWNER_USER_ID OWNER OPTIONAL_FLAG APPROVER_USER_ID APPROVER ACTION_RULE_EXISTS_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT qipb.inspection_plan_id, qipb.asset_id, qipb.asset_group_id, qipb.object_version_number, qipb.organization_id, qipb.inspection_plan_code, qipb.version_number, qipt.NAME, qipt.description, qipb.inspection_plan_type, qipb.inspection_plan_status, qipb.enabled_flag, qipb.effective_start_date, qipb.effective_end_date, qipb.inspection_level_id, qipb.inventory_item_id, qipb.revision, CAST(0 as number(18)) revision_id, qipb.category_set_id, qipb.category_id, qipb.work_center_id, qipb.resource_id, CAST(0 as number(18)) owner_user_id, qipb.owner, qipb.optional_flag, CAST(0 as number(18)) approver_user_id, qipb.approver, qipb.action_rule_exists_flag, qipb.created_by, qipb.creation_date, qipb.last_updated_by, qipb.last_update_date, qipb.last_update_login FROM qa_inspection_plans_b qipb, qa_inspection_plans_tl qipt WHERE qipb.inspection_plan_id = qipt.inspection_plan_id AND qipt.language = userenv('LANG')