View: MSC_FLP_END_DEMAND_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_FLP_END_DEMAND_V

View Text

SELECT MFP.ROWID
, MFP.ORGANIZATION_ID
, MFP.PLAN_ID
, MFP.PEGGING_ID
, MFP.TRANSACTION_ID
, MFP.DEMAND_ID
, NVL(MFP.PREV_PEGGING_ID
, -1)
, MFP.INVENTORY_ITEM_ID
, DECODE(MFP.DEMAND_ID
, -1
, ROUND(MFP.ALLOCATED_QUANTITY
, 2)
, ROUND(MGR.USING_REQUIREMENT_QUANTITY
, 2))
, ROUND(MR.NEW_ORDER_QUANTITY
, 2)
, ROUND(MFP.ALLOCATED_QUANTITY
, 2)
, DECODE(MFP.DEMAND_ID
, -1
, MR.NEW_SCHEDULE_DATE
, MGR.USING_ASSEMBLY_DEMAND_DATE)
, DECODE(MFP.DEMAND_ID
, -1
, MSC_GET_NAME.LOOKUP_MEANING('MRP_FLP_SUPPLY_DEMAND_TYPE'
, MFP.DEMAND_ID) ||'/'|| DECODE(MFP.SUPPLY_TYPE
, 10
, MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE'
, 5)
, 13
, MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE'
, 5)
, 18
, MSC_GET_NAME.LOOKUP_MEANING('MRP_FLP_SUPPLY_DEMAND_TYPE'
, 18)
, MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE'
, MFP.SUPPLY_TYPE))
, -2
, MSC_GET_NAME.LOOKUP_MEANING('MRP_FLP_SUPPLY_DEMAND_TYPE'
, MFP.DEMAND_ID)
, -3
, MSC_GET_NAME.LOOKUP_MEANING('MRP_FLP_SUPPLY_DEMAND_TYPE'
, MFP.DEMAND_ID)
, MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION'
, MGR.ORIGINATION_TYPE))
, DECODE(MGR.ORIGINATION_TYPE
, 6
, MGR.ORDER_NUMBER
, MSC_GET_NAME.SUPPLY_ORDER(MGR.ORIGINATION_TYPE
, MGR.DEMAND_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID))
, MIF.ITEM_NAME||'/'|| MSC_GET_NAME.ORG_CODE(MFP.ORGANIZATION_ID
, MFP.SR_INSTANCE_ID)
, SUBSTR(MSC_GET_NAME.ITEM_DESC(MFP.INVENTORY_ITEM_ID
, MFP.ORGANIZATION_ID
, MFP.PLAN_ID
, MFP.SR_INSTANCE_ID)
, 1
, 20)
, DECODE(MFP.DEMAND_ID
, -1
, MSC_GET_NAME.PROJECT(MFP.PROJECT_ID
, MFP.ORGANIZATION_ID
, MFP.PLAN_ID
, MFP.SR_INSTANCE_ID)
, -3
, MSC_GET_NAME.PROJECT(MFP.PROJECT_ID
, MFP.ORGANIZATION_ID
, MFP.PLAN_ID
, MFP.SR_INSTANCE_ID)
, MSC_GET_NAME.PROJECT(MGR.PROJECT_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID))
, DECODE(MFP.DEMAND_ID
, -1
, MSC_GET_NAME.TASK(MFP.TASK_ID
, MFP.PROJECT_ID
, MFP.ORGANIZATION_ID
, MFP.PLAN_ID
, MFP.SR_INSTANCE_ID)
, -3
, MSC_GET_NAME.TASK(MFP.TASK_ID
, MFP.PROJECT_ID
, MFP.ORGANIZATION_ID
, MFP.PLAN_ID
, MFP.SR_INSTANCE_ID)
, MSC_GET_NAME.TASK(MGR.TASK_ID
, MGR.PROJECT_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID))
, MGR.DEMAND_CLASS
, MGR.UNIT_NUMBER
, MSC_GET_NAME.PROJECT(MGR.LENDING_PROJECT_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID)
, MSC_GET_NAME.TASK(MGR.LENDING_TASK_ID
, MGR.LENDING_PROJECT_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID)
, MFP.SR_INSTANCE_ID
, MGR.DMD_SATISFIED_DATE
, MSC_GET_NAME.CUSTOMER(MGR.CUSTOMER_ID)
, MGR.DEMAND_PRIORITY
, MGR.ATTRIBUTE1
FROM MSC_ITEMS MIF
, MSC_SUPPLIES MR
, MSC_DEMANDS MGR
, MSC_FULL_PEGGING MFP
WHERE MGR.DEMAND_ID(+) = MFP.DEMAND_ID
AND MGR.PLAN_ID (+)= MFP.PLAN_ID
AND MR.TRANSACTION_ID(+) = MFP.TRANSACTION_ID
AND MR.PLAN_ID (+)= MFP.PLAN_ID
AND MIF.INVENTORY_ITEM_ID = MFP.INVENTORY_ITEM_ID
AND MFP.PREV_PEGGING_ID IS NULL

Columns