Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT X.TRANSACTION_ID
, X.BILL_OF_RESOURCES
, X.ORGANIZATION_ID
, X.ASSEMBLY_ITEM_ID
, X.SOURCE_ITEM_ID
, X.RESOURCE_ID
, X.RESOURCE_DEPARTMENT_HOURS
, X.OPERATION_SEQUENCE_ID
, X.OPERATION_SEQ_NUM
, X.RESOURCE_SEQ_NUM
, X.SETBACK_DAYS
, X.DEPARTMENT_ID
, X.LINE_ID
, X.ASSEMBLY_USAGE
, X.ORIGINATION_TYPE
, X.RESOURCE_UNITS
, X.BASIS
, X.RN RN3
, Y.RN RN2
, MP.RN RN1
FROM ( SELECT NVL(BASE_ITEM_ID
, INVENTORY_ITEM_ID) ITEM_ID
, ORGANIZATION_ID ORG_ID
, MAX(RN) RN
FROM MRP_AP_SYS_ITEMS_SN MSIK GROUP BY NVL(BASE_ITEM_ID
, INVENTORY_ITEM_ID)
, ORGANIZATION_ID) Y
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_RES_HRS_SN X
WHERE X.ASSEMBLY_ITEM_ID = Y.ITEM_ID
AND X.ORGANIZATION_ID = Y.ORG_ID
AND MP.ORGANIZATION_ID= X.ORGANIZATION_ID