VIEW: APPS.MSC_FLP_END_DEMAND_V

Source

View Text - Preformatted

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('MSC_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,80) , 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 ,substrb(nvl(MIF.Description , MIF.ITEM_name),1,80)||'/'|| msc_get_name.org_code(mgr.organization_id,mgr.sr_instance_id) 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

View Text - HTML Formatted

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('MSC_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
, 80)
, 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
, SUBSTRB(NVL(MIF.DESCRIPTION
, MIF.ITEM_NAME)
, 1
, 80)||'/'|| MSC_GET_NAME.ORG_CODE(MGR.ORGANIZATION_ID
, MGR.SR_INSTANCE_ID)
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