WIE_WO_OP_OUTPUT_DETAIL_V

Details

• Schema: FUSION

• Object owner: WIE

• Object type: VIEW

Columns

Name

WO_OPERATION_OUTPUT_ID OBJECT_VERSION_NUMBER ORGANIZATION_ID WO_OPERATION_ID WORK_ORDER_ID INVENTORY_ITEM_ID OUTPUT_SEQ_NUMBER OUTPUT_TYPE OUTPUT_QUANTITY COMPLETION_TYPE COMPLETED_QUANTITY UOM_CODE COMPL_SUBINVENTORY_CODE COMPL_LOCATOR_ID PRIMARY_FLAG COST_ALLOCATION_PERCENTAGE WD_OPERATION_OUTPUT_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE PJC_CONTEXT_CATEGORY PJC_PROJECT_ID PJC_PROJECT_NUMBER PJC_TASK_ID PJC_TASK_NUMBER PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_BILLABLE_FLAG PJC_CAPITALIZABLE_FLAG PJC_WORK_TYPE_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID PJC_FUNDING_ALLOCATION_ID PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE10

Query

SQL_Statement

SELECT WOOO.WO_OPERATION_OUTPUT_ID, WOOO.OBJECT_VERSION_NUMBER, WOOO.ORGANIZATION_ID, WOOO.WO_OPERATION_ID, WOOO.WORK_ORDER_ID, WOOO.INVENTORY_ITEM_ID, WOOO.OUTPUT_SEQ_NUMBER, WOOO.OUTPUT_TYPE, WOOO.OUTPUT_QUANTITY, WOOO.COMPLETION_TYPE, WOOO.COMPLETED_QUANTITY, WOOO.UOM_CODE, WOOO.COMPL_SUBINVENTORY_CODE, WOOO.COMPL_LOCATOR_ID, WOOO.PRIMARY_FLAG, WOOO.COST_ALLOCATION_PERCENTAGE, WOOO.WD_OPERATION_OUTPUT_ID, WOOO.CREATED_BY, WOOO.CREATION_DATE, WOOO.LAST_UPDATED_BY, WOOO.LAST_UPDATE_DATE,WOOO.LAST_UPDATE_LOGIN, WOOO.REQUEST_ID, WOOO.JOB_DEFINITION_NAME, WOOO.JOB_DEFINITION_PACKAGE, WO.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY, WO.PJC_PROJECT_ID PJC_PROJECT_ID, WO.PJC_PROJECT_NUMBER PJC_PROJECT_NUMBER, WO.PJC_TASK_ID PJC_TASK_ID, WO.PJC_TASK_NUMBER PJC_TASK_NUMBER, WO.PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_TYPE_ID, WO.PJC_EXPENDITURE_ITEM_DATE PJC_EXPENDITURE_ITEM_DATE, WO.PJC_ORGANIZATION_ID PJC_ORGANIZATION_ID, WO.PJC_BILLABLE_FLAG PJC_BILLABLE_FLAG, WO.PJC_CAPITALIZABLE_FLAG PJC_CAPITALIZABLE_FLAG, WO.PJC_WORK_TYPE_ID PJC_WORK_TYPE_ID, WO.PJC_CONTRACT_ID PJC_CONTRACT_ID, WO.PJC_CONTRACT_LINE_ID PJC_CONTRACT_LINE_ID, WO.PJC_FUNDING_ALLOCATION_ID PJC_FUNDING_ALLOCATION_ID, WO.PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE1, WO.PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE2, WO.PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE3, WO.PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE4, WO.PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE5, WO.PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE6, WO.PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE7, WO.PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE8, WO.PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE9, WO.PJC_RESERVED_ATTRIBUTE10 PJC_RESERVED_ATTRIBUTE10, WO.PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE1, WO.PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE2, WO.PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE3, WO.PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE4, WO.PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE5, WO.PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE6, WO.PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE7, WO.PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE8, WO.PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE9, WO.PJC_USER_DEF_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE10 FROM WIE_WO_OPERATION_OUTPUTS WOOO INNER JOIN WIE_WORK_ORDERS_B WO ON WOOO.WORK_ORDER_ID = WO.WORK_ORDER_ID UNION ALL ( SELECT DISTINCT NULL AS WO_OPERATION_OUTPUT_ID,WO.OBJECT_VERSION_NUMBER, WO.ORGANIZATION_ID, CAST(FIRST_VALUE(WOO.WO_OPERATION_ID) OVER (PARTITION BY WO.WORK_ORDER_ID ORDER BY WOO.OPERATION_SEQ_NUMBER DESC) AS NUMBER(18)) AS WO_OPERATION_ID, WO.WORK_ORDER_ID, CAST(NULL AS NUMBER(18)) AS INVENTORY_ITEM_ID,NULL AS OUTPUT_SEQ_NUMBER,NULL AS OUTPUT_TYPE, WO.PLANNED_START_QUANTITY AS OUTPUT_QUANTITY, NULL AS COMPLETION_TYPE, WO.COMPLETED_QUANTITY AS COMPLETED_QUANTITY, NULL AS UOM_CODE, NULL AS COMPL_SUBINVENTORY_CODE, NULL AS COMPL_LOCATOR_ID, NULL AS PRIMARY_FLAG, NULL AS COST_ALLOCATION_PERCENTAGE,NULL AS WD_OPERATION_OUTPUT_ID, WO.CREATED_BY, WO.CREATION_DATE, WO.LAST_UPDATED_BY, WO.LAST_UPDATE_DATE,WO.LAST_UPDATE_LOGIN, WO.REQUEST_ID, WO.JOB_DEFINITION_NAME, WO.JOB_DEFINITION_PACKAGE, WO.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY, WO.PJC_PROJECT_ID PJC_PROJECT_ID, WO.PJC_PROJECT_NUMBER PJC_PROJECT_NUMBER, WO.PJC_TASK_ID PJC_TASK_ID, WO.PJC_TASK_NUMBER PJC_TASK_NUMBER, WO.PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_TYPE_ID, WO.PJC_EXPENDITURE_ITEM_DATE PJC_EXPENDITURE_ITEM_DATE, WO.PJC_ORGANIZATION_ID PJC_ORGANIZATION_ID, WO.PJC_BILLABLE_FLAG PJC_BILLABLE_FLAG, WO.PJC_CAPITALIZABLE_FLAG PJC_CAPITALIZABLE_FLAG, WO.PJC_WORK_TYPE_ID PJC_WORK_TYPE_ID, WO.PJC_CONTRACT_ID PJC_CONTRACT_ID, WO.PJC_CONTRACT_LINE_ID PJC_CONTRACT_LINE_ID, WO.PJC_FUNDING_ALLOCATION_ID PJC_FUNDING_ALLOCATION_ID, WO.PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE1, WO.PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE2, WO.PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE3, WO.PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE4, WO.PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE5, WO.PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE6, WO.PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE7, WO.PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE8, WO.PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE9, WO.PJC_RESERVED_ATTRIBUTE10 PJC_RESERVED_ATTRIBUTE10, WO.PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE1, WO.PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE2, WO.PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE3, WO.PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE4, WO.PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE5, WO.PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE6, WO.PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE7, WO.PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE8, WO.PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE9, WO.PJC_USER_DEF_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE10 FROM WIE_WORK_ORDERS_B WO INNER JOIN WIS_WORK_METHODS_B WM ON WO.WORK_METHOD_ID = WM.WORK_METHOD_ID AND WM.WORK_METHOD_CODE = 'DISCRETE_MANUFACTURING' LEFT OUTER JOIN WIE_WO_OPERATIONS_B WOO ON WO.WORK_ORDER_ID = WOO.WORK_ORDER_ID )