View: MSC_FLP_DEMAND_SUPPLY_V

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

View Text

SELECT MFP2.ROWID
, MFP2.PLAN_ID
, MFP2.ORGANIZATION_ID
, MFP2.PEGGING_ID
, NVL(MFP2.PREV_PEGGING_ID
, -1)
, MFP2.DEMAND_ID
, MFP2.TRANSACTION_ID
, MFP2.END_ITEM_USAGE
, MFP2.INVENTORY_ITEM_ID
, MIF2.ITEM_NAME||'/'|| MSC_GET_NAME.ORG_CODE(MFP2.ORGANIZATION_ID
, MFP2.SR_INSTANCE_ID)
, ROUND(MR2.NEW_ORDER_QUANTITY
, 6)
, ROUND(MFP2.ALLOCATED_QUANTITY
, 6)
, MR2.NEW_SCHEDULE_DATE
, ROUND(MGR2.USING_REQUIREMENT_QUANTITY
, 6)
, MSC_GET_NAME.DEMAND_DATE(MFP2.PEGGING_ID
, MFP2.PLAN_ID)
, MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE'
, MR2.ORDER_TYPE)
, MSC_GET_NAME.PROJECT(MFP2.PROJECT_ID
, MFP2.ORGANIZATION_ID
, MFP2.PLAN_ID
, MFP2.SR_INSTANCE_ID)
, MSC_GET_NAME.TASK(MFP2.TASK_ID
, MFP2.PROJECT_ID
, MFP2.ORGANIZATION_ID
, MFP2.PLAN_ID
, MFP2.SR_INSTANCE_ID)
, MR2.ORDER_TYPE
, DECODE(MR2.ORDER_TYPE
, 5
, TO_CHAR(MR2.TRANSACTION_ID)
, MR2.ORDER_NUMBER)
, DECODE(MFP2.END_ITEM_USAGE
, NULL
, 0
, ROUND(MFP2.ALLOCATED_QUANTITY/MFP2.END_ITEM_USAGE
, 6))
, DECODE(MFP3.DEMAND_ID
, -1
, ROUND(MFP3.ALLOCATED_QUANTITY
, 6)
, ROUND(MGR3.USING_REQUIREMENT_QUANTITY
, 6))
, DECODE(MFP3.DEMAND_ID
, -1
, MSC_GET_NAME.SUPPLY_DATE(MFP3.PEGGING_ID
, MFP3.PLAN_ID)
, MSC_GET_NAME.DEMAND_DATE(MFP3.PEGGING_ID
, MFP3.PLAN_ID))
, MIF3.ITEM_NAME||'/'|| MSC_GET_NAME.ORG_CODE(MFP3.ORGANIZATION_ID
, MFP3.SR_INSTANCE_ID)
, SUBSTR(MSC_GET_NAME.ITEM_DESC(MFP3.INVENTORY_ITEM_ID
, MFP3.ORGANIZATION_ID
, MFP3.PLAN_ID
, MFP3.SR_INSTANCE_ID)
, 1
, 20)
, DECODE(MGR3.DEMAND_ID
, -1
, MSC_GET_NAME.LOOKUP_MEANING('MRP_FLP_SUPPLY_DEMAND_TYPE'
, MGR3.DEMAND_ID)
, -2
, MSC_GET_NAME.LOOKUP_MEANING('MRP_FLP_SUPPLY_DEMAND_TYPE'
, MGR3.DEMAND_ID)
, -3
, MSC_GET_NAME.LOOKUP_MEANING('MRP_FLP_SUPPLY_DEMAND_TYPE'
, MGR3.DEMAND_ID)
, MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION'
, MGR3.ORIGINATION_TYPE))
, DECODE(MGR3.ORIGINATION_TYPE
, 6
, MGR3.ORDER_NUMBER
, MSC_GET_NAME.SUPPLY_ORDER(MGR3.ORIGINATION_TYPE
, MGR3.DEMAND_ID
, MGR3.ORGANIZATION_ID
, MGR3.PLAN_ID
, MGR3.SR_INSTANCE_ID))
, MSC_GET_NAME.PROJECT(MFP3.PROJECT_ID
, MFP3.ORGANIZATION_ID
, MFP3.PLAN_ID
, MFP3.SR_INSTANCE_ID)
, MSC_GET_NAME.TASK(MFP3.TASK_ID
, MFP3.PROJECT_ID
, MFP3.ORGANIZATION_ID
, MFP3.PLAN_ID
, MFP3.SR_INSTANCE_ID)
, MGR3.DEMAND_CLASS
, MR2.UNIT_NUMBER
, MGR3.UNIT_NUMBER
, MSC_GET_NAME.ITEM_DESC(MFP2.INVENTORY_ITEM_ID
, MFP2.ORGANIZATION_ID
, MFP2.PLAN_ID
, MFP2.SR_INSTANCE_ID)
, MSC_GET_NAME.PROJECT(MGR3.LENDING_PROJECT_ID
, MGR3.ORGANIZATION_ID
, MGR3.PLAN_ID
, MGR3.SR_INSTANCE_ID)
, MSC_GET_NAME.TASK(MGR3.LENDING_TASK_ID
, MGR3.LENDING_PROJECT_ID
, MGR3.ORGANIZATION_ID
, MGR3.PLAN_ID
, MGR3.SR_INSTANCE_ID)
, MFP2.SR_INSTANCE_ID
, MR2.NEED_BY_DATE
, NVL(MSC_GET_NAME.ORG_CODE(MR2.SOURCE_ORGANIZATION_ID
, MR2.SOURCE_SR_INSTANCE_ID)
, MSC_GET_NAME.SUPPLIER(MR2.SOURCE_SUPPLIER_ID))
, MSC_GET_NAME.CUSTOMER(MGR3.CUSTOMER_ID)
, MGR3.DEMAND_PRIORITY
, MGR3.DMD_SATISFIED_DATE
, MGR3.ATTRIBUTE1
, MGR3.ATTRIBUTE2
, MGR3.ATTRIBUTE3
, MGR3.ATTRIBUTE4
, MGR3.ATTRIBUTE5
, MGR3.ATTRIBUTE6
, MGR3.ATTRIBUTE7
, MGR3.ATTRIBUTE8
, MGR3.ATTRIBUTE9
, MGR3.ATTRIBUTE10
, MGR3.ATTRIBUTE11
, MGR3.ATTRIBUTE12
, MGR3.ATTRIBUTE13
, MGR3.ATTRIBUTE14
, MGR3.ATTRIBUTE15
FROM MSC_ITEMS MIF3
, MSC_ITEMS MIF2
, MSC_DEMANDS MGR3
, MSC_DEMANDS MGR2
, MSC_SUPPLIES MR2
, MSC_FULL_PEGGING MFP3
, MSC_FULL_PEGGING MFP2
WHERE MGR3.DEMAND_ID(+) = MFP3.DEMAND_ID
AND MGR3.PLAN_ID(+)= MFP3.PLAN_ID
AND MGR2.DEMAND_ID(+)=MFP2.DEMAND_ID
AND MGR2.PLAN_ID(+)=MFP2.PLAN_ID
AND MIF3.INVENTORY_ITEM_ID = MFP3.INVENTORY_ITEM_ID
AND MFP3.PEGGING_ID = MFP2.END_PEGGING_ID
AND MFP3.PLAN_ID = MFP2.PLAN_ID
AND MR2.TRANSACTION_ID = MFP2.TRANSACTION_ID
AND MR2.PLAN_ID = MFP2.PLAN_ID
AND MIF2.INVENTORY_ITEM_ID = MFP2.INVENTORY_ITEM_ID

Columns