WIE_WO_DEMAND

Details

Schema: FUSION
Object owner: WIE
Object type: VIEW

Columns

Name
ORGANIZATION_ID WORK_ORDER_ID WORK_ORDER_NUMBER WORK_ORDER_DESCRIPTION WORK_METHOD_ID WORK_METHOD_CODE WORK_ORDER_STATUS_ID USER_STATUS_CODE SYSTEM_STATUS_CODE WO_OPERATION_MATERIAL_ID WO_OPERATION_ID OPERATION_SEQ_NUMBER OPERATION_NAME WORK_CENTER_ID MATERIAL_SEQ_NUMBER INVENTORY_ITEM_ID UOM_CODE QUANTITY_PER_PRODUCT YIELD_FACTOR REQUIRED_DATE BASIS_TYPE SUPPLY_TYPE REQUIRED_QUANTITY ISSUED_QUANTITY DEMAND_QUANTITY

Name

ORGANIZATION_ID

WORK_ORDER_ID

WORK_ORDER_NUMBER

WORK_ORDER_DESCRIPTION

WORK_METHOD_ID

WORK_METHOD_CODE

WORK_ORDER_STATUS_ID

USER_STATUS_CODE

SYSTEM_STATUS_CODE

WO_OPERATION_MATERIAL_ID

WO_OPERATION_ID

OPERATION_SEQ_NUMBER

OPERATION_NAME

WORK_CENTER_ID

MATERIAL_SEQ_NUMBER

INVENTORY_ITEM_ID

UOM_CODE

QUANTITY_PER_PRODUCT

YIELD_FACTOR

REQUIRED_DATE

BASIS_TYPE

SUPPLY_TYPE

REQUIRED_QUANTITY

ISSUED_QUANTITY

DEMAND_QUANTITY

Query

SQL_Statement
SELECT WWO.ORGANIZATION_ID ORGANIZATION_ID, WWO.WORK_ORDER_ID WORK_ORDER_ID, WWO.WORK_ORDER_NUMBER WORK_ORDER_NUMBER, WWO.WORK_ORDER_DESCRIPTION WORK_ORDER_DESCRIPTION, WWO.WORK_METHOD_ID WORK_METHOD_ID, WWM.WORK_METHOD_CODE WORK_METHOD_CODE, WWO.WORK_ORDER_STATUS_ID WORK_ORDER_STATUS_ID, WWS.WO_STATUS_CODE USER_STATUS_CODE, WWS.WO_SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE, WWOM.WO_OPERATION_MATERIAL_ID WO_OPERATION_MATERIAL_ID, WWOM.WO_OPERATION_ID WO_OPERATION_ID, WWOO.OPERATION_SEQ_NUMBER OPERATION_SEQ_NUMBER, WWOO.OPERATION_NAME OPERATION_NAME, WWOO.WORK_CENTER_ID WORK_CENTER_ID, WWOM.MATERIAL_SEQ_NUMBER MATERIAL_SEQ_NUMBER, WWOM.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, WWOM.UOM_CODE UOM_CODE, WWOM.QUANTITY_PER_PRODUCT QUANTITY_PER_PRODUCT, WWOM.YIELD_FACTOR YIELD_FACTOR, WWOM.REQUIRED_DATE REQUIRED_DATE, WWOM.BASIS_TYPE BASIS_TYPE, WWOM.SUPPLY_TYPE SUPPLY_TYPE, WWOM.QUANTITY REQUIRED_QUANTITY, NVL(WWOM.ISSUED_QUANTITY, 0) ISSUED_QUANTITY, DECODE(WWS.WO_SYSTEM_STATUS_CODE, 'CANCELED', 0, 'CLOSED', 0, NVL(WWOM.QUANTITY,0) - NVL(WWOM.ISSUED_QUANTITY, 0)) DEMAND_QUANTITY FROM WIE_WO_OPERATION_MATERIALS WWOM, WIE_WORK_ORDERS_VL WWO, WIE_WO_OPERATIONS_VL WWOO, WIE_WO_STATUSES_VL WWS, WIS_WORK_METHODS_VL WWM WHERE WWOM.MATERIAL_TYPE = 'COMPONENT' AND WWOM.WORK_ORDER_ID = WWO.WORK_ORDER_ID AND WWOO.WO_OPERATION_ID = WWOM.WO_OPERATION_ID AND WWS.WO_STATUS_ID = WWO.WORK_ORDER_STATUS_ID AND WWM.WORK_METHOD_ID = WWO.WORK_METHOD_ID

SQL_Statement

SELECT

WWO.ORGANIZATION_ID ORGANIZATION_ID,

WWO.WORK_ORDER_ID WORK_ORDER_ID,

WWO.WORK_ORDER_NUMBER WORK_ORDER_NUMBER,

WWO.WORK_ORDER_DESCRIPTION WORK_ORDER_DESCRIPTION,

WWO.WORK_METHOD_ID WORK_METHOD_ID,

WWM.WORK_METHOD_CODE WORK_METHOD_CODE,

WWO.WORK_ORDER_STATUS_ID WORK_ORDER_STATUS_ID,

WWS.WO_STATUS_CODE USER_STATUS_CODE,

WWS.WO_SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE,

WWOM.WO_OPERATION_MATERIAL_ID WO_OPERATION_MATERIAL_ID,

WWOM.WO_OPERATION_ID WO_OPERATION_ID,

WWOO.OPERATION_SEQ_NUMBER OPERATION_SEQ_NUMBER,

WWOO.OPERATION_NAME OPERATION_NAME,

WWOO.WORK_CENTER_ID WORK_CENTER_ID,

WWOM.MATERIAL_SEQ_NUMBER MATERIAL_SEQ_NUMBER,

WWOM.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,

WWOM.UOM_CODE UOM_CODE,

WWOM.QUANTITY_PER_PRODUCT QUANTITY_PER_PRODUCT,

WWOM.YIELD_FACTOR YIELD_FACTOR,

WWOM.REQUIRED_DATE REQUIRED_DATE,

WWOM.BASIS_TYPE BASIS_TYPE,

WWOM.SUPPLY_TYPE SUPPLY_TYPE,

WWOM.QUANTITY REQUIRED_QUANTITY,

NVL(WWOM.ISSUED_QUANTITY, 0) ISSUED_QUANTITY,

DECODE(WWS.WO_SYSTEM_STATUS_CODE, 'CANCELED', 0, 'CLOSED', 0, NVL(WWOM.QUANTITY,0) - NVL(WWOM.ISSUED_QUANTITY, 0)) DEMAND_QUANTITY

FROM WIE_WO_OPERATION_MATERIALS WWOM,

WIE_WORK_ORDERS_VL WWO,

WIE_WO_OPERATIONS_VL WWOO,

WIE_WO_STATUSES_VL WWS,

WIS_WORK_METHODS_VL WWM

WHERE WWOM.MATERIAL_TYPE = 'COMPONENT'

AND WWOM.WORK_ORDER_ID = WWO.WORK_ORDER_ID

AND WWOO.WO_OPERATION_ID = WWOM.WO_OPERATION_ID

AND WWS.WO_STATUS_ID = WWO.WORK_ORDER_STATUS_ID

AND WWM.WORK_METHOD_ID = WWO.WORK_METHOD_ID