VIEW: APPS.MSC_FLP_END_DEMAND2_V

Source

View Text - Preformatted

SELECT MGR.ROWID , MGR.DEMAND_ID , MGR.INVENTORY_ITEM_ID , MGR.ORGANIZATION_ID , MGR.plan_id , MGR.USING_ASSEMBLY_DEMAND_DATE , MGR.ASSEMBLY_DEMAND_COMP_DATE , ROUND(MGR.USING_REQUIREMENT_QUANTITY,2) , MGR.DEMAND_TYPE , MGR.ORIGINATION_TYPE , 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(mgr.organization_id,mgr.sr_instance_id) , SUBSTR(msc_get_name.item_desc(mgr.inventory_item_id, mgr.organization_id, mgr.plan_id,mgr.sr_instance_id),1,20) , Msc_GET_name.PROJECT(Mgr.PROJECT_ID,mgr.organization_id, mgr.plan_id, mgr.sr_instance_id) , Msc_GET_name.TASK(Mgr.TASK_ID, mgr.project_id,mgr.organization_id, mgr.plan_id,mgr.sr_instance_id) , 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) ,mgr.sr_instance_id ,mgr.dmd_satisfied_date ,msc_get_name.customer(mgr.customer_id) ,mgr.demand_priority ,mgr.attribute1 FROM Msc_items MIF, Msc_demands MGR WHERE MIF.INVENTORY_ITEM_ID = MGR.INVENTORY_ITEM_ID

View Text - HTML Formatted

SELECT MGR.ROWID
, MGR.DEMAND_ID
, MGR.INVENTORY_ITEM_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.USING_ASSEMBLY_DEMAND_DATE
, MGR.ASSEMBLY_DEMAND_COMP_DATE
, ROUND(MGR.USING_REQUIREMENT_QUANTITY
, 2)
, MGR.DEMAND_TYPE
, MGR.ORIGINATION_TYPE
, 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(MGR.ORGANIZATION_ID
, MGR.SR_INSTANCE_ID)
, SUBSTR(MSC_GET_NAME.ITEM_DESC(MGR.INVENTORY_ITEM_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID)
, 1
, 20)
, MSC_GET_NAME.PROJECT(MGR.PROJECT_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID)
, MSC_GET_NAME.TASK(MGR.TASK_ID
, MGR.PROJECT_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID)
, 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)
, MGR.SR_INSTANCE_ID
, MGR.DMD_SATISFIED_DATE
, MSC_GET_NAME.CUSTOMER(MGR.CUSTOMER_ID)
, MGR.DEMAND_PRIORITY
, MGR.ATTRIBUTE1
FROM MSC_ITEMS MIF
, MSC_DEMANDS MGR
WHERE MIF.INVENTORY_ITEM_ID = MGR.INVENTORY_ITEM_ID