View: MRP_AP_HARD_RESERVATIONS_V

View Text

SELECT X.INVENTORY_ITEM_ID
, X.ORGANIZATION_ID
, X.DEMAND_ID
, X.PARENT_DEMAND_ID
, X.DISPOSITION_ID
, X.REQUIREMENT_DATE
, X.REVISION
, X.RESERVED_QUANTITY
, X.DISPOSITION_TYPE
, X.SUBINVENTORY
, X.RESERVATION_TYPE
, X.DEMAND_CLASS
, X.AVAILABLE_TO_MRP
, X.PROJECT_ID
, X.TASK_ID
, MPP.PLANNING_GROUP
, NVL(MPP.RN
, 0) RN6
, X.RN5 RN5
, X.RN4 RN4
, X.RN3 RN3
, X.RN2 RN2
, X.RN1 RN1
FROM MRP_AP_PRJ_PARAS_SN MPP
, ( SELECT MD.INVENTORY_ITEM_ID
, MD.ORGANIZATION_ID
, MD.DEMAND_ID
, MD.PARENT_DEMAND_ID
, MD.DEMAND_SOURCE_HEADER_ID DISPOSITION_ID
, MD.REQUIREMENT_DATE
, MD.REVISION
, MD.PRIMARY_UOM_QUANTITY-MD.COMPLETED_QUANTITY RESERVED_QUANTITY
, DECODE( MD.DEMAND_SOURCE_TYPE
, 3
, 3
, 2) DISPOSITION_TYPE
, MD.SUBINVENTORY
, MD.RESERVATION_TYPE
, MD.DEMAND_CLASS
, MD.AVAILABLE_TO_MRP
, NVL( SLA.PROJECT_ID
, SLAP.PROJECT_ID) PROJECT_ID
, NVL( SLA.TASK_ID
, SLAP.TASK_ID) TASK_ID
, NVL(SLAP.RN
, 0) RN5
, NVL(SLA.RN
, 0) RN4
, MD.RN RN3
, MSIK.RN RN2
, MP.RN RN1
FROM MRP_AP_SO_LINES_SN SLA
, MRP_AP_SO_LINES_SN SLAP
, MRP_AP_SYS_ITEMS_SN MSIK
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_DEMAND_SN MD
WHERE SLA.LINE_ID (+)= TO_NUMBER(MD.DEMAND_SOURCE_LINE)
AND SLAP.LINE_ID (+) = NVL(SLA.PARENT_LINE_ID
, SLA.LINE_ID)
AND MD.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND MD.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND MD.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND MD.RESERVATION_TYPE = 2
AND MD.PRIMARY_UOM_QUANTITY > NVL( MD.COMPLETED_QUANTITY
, 0)
AND MD.DEMAND_SOURCE_TYPE IN (2
, 8
, 3) ) X
WHERE MPP.PROJECT_ID (+)= X.PROJECT_ID
AND MPP.ORGANIZATION_ID (+)= X.ORGANIZATION_ID

Columns