CST_WORK_DEFINITION_ITEMS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

WORK_DEFINITION_ITEM_ID SCENARIO_ID INVENTORY_ITEM_ID INVENTORY_ORG_ID STATUS_CODE WORK_DEFINITION_VERSION_ID WD_CRITERION_DETAIL_ID REFERENCE_ID REFERENCE_SCENARIO_ID ITEM_COST_PROFILE_ID ASSET_COST_PROFILE_ID EXPENSE_COST_PROFILE_ID ASSET_VAL_UNIT_ID EXPENSE_VAL_UNIT_ID WORK_ORDER_ID SCENARIO_EVENT_ID WD_OPERATION_COUNT WD_MATERIAL_COUNT WD_RESOURCE_COUNT PUBLISHED_FLAG OUTPUT_TYPE WORK_METHOD_CODE PO_LINE_LOCATION_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE

Query

SQL_Statement

SELECT A.WORK_DEFINITION_ITEM_ID, A.SCENARIO_ID, A.INVENTORY_ITEM_ID, A.INVENTORY_ORG_ID, A.STATUS_CODE, A.WORK_DEFINITION_VERSION_ID, A.WD_CRITERION_DETAIL_ID, A.REFERENCE_ID, A.REFERENCE_SCENARIO_ID, A.ITEM_COST_PROFILE_ID, A.ASSET_COST_PROFILE_ID, A.EXPENSE_COST_PROFILE_ID, A.ASSET_VAL_UNIT_ID, A.EXPENSE_VAL_UNIT_ID, A.WORK_ORDER_ID, A.SCENARIO_EVENT_ID, A.WD_OPERATION_COUNT, A.WD_MATERIAL_COUNT, A.WD_RESOURCE_COUNT, A.PUBLISHED_FLAG, A.OUTPUT_TYPE, A.WORK_METHOD_CODE, A.PO_LINE_LOCATION_ID, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN, A.REQUEST_ID, A.JOB_DEFINITION_NAME, A.JOB_DEFINITION_PACKAGE FROM CST_WORK_DEFINITION_ITEMS A WHERE A.REFERENCE_ID IS NULL UNION ALL SELECT A.WORK_DEFINITION_ITEM_ID, A.SCENARIO_ID, A.INVENTORY_ITEM_ID, A.INVENTORY_ORG_ID, A.STATUS_CODE, B.WORK_DEFINITION_VERSION_ID, A.WD_CRITERION_DETAIL_ID, A.REFERENCE_ID, A.REFERENCE_SCENARIO_ID, B.ITEM_COST_PROFILE_ID, B.ASSET_COST_PROFILE_ID, B.EXPENSE_COST_PROFILE_ID, B.ASSET_VAL_UNIT_ID, B.EXPENSE_VAL_UNIT_ID, B.WORK_ORDER_ID, A.SCENARIO_EVENT_ID, B.WD_OPERATION_COUNT, B.WD_MATERIAL_COUNT, B.WD_RESOURCE_COUNT, A.PUBLISHED_FLAG, B.OUTPUT_TYPE, B.WORK_METHOD_CODE, B.PO_LINE_LOCATION_ID, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN, A.REQUEST_ID, A.JOB_DEFINITION_NAME, A.JOB_DEFINITION_PACKAGE FROM CST_WORK_DEFINITION_ITEMS A, CST_WORK_DEFINITION_ITEMS B WHERE A.REFERENCE_ID = B.WORK_DEFINITION_ITEM_ID