VIEW: APPS.MSC_LATE_ORDERS_MV_V

Source

View Text - Preformatted

SELECT md.plan_id, md.organization_id, md.sr_instance_id, md.inventory_item_id, md.project_id, md.task_id, med.date1, md.demand_id from msc_demands md, msc_exception_details med WHERE med.number1 = md.demand_id and med.plan_id = md.plan_id and med.exception_type in (13,14,24,26)

View Text - HTML Formatted

SELECT MD.PLAN_ID
, MD.ORGANIZATION_ID
, MD.SR_INSTANCE_ID
, MD.INVENTORY_ITEM_ID
, MD.PROJECT_ID
, MD.TASK_ID
, MED.DATE1
, MD.DEMAND_ID
FROM MSC_DEMANDS MD
, MSC_EXCEPTION_DETAILS MED
WHERE MED.NUMBER1 = MD.DEMAND_ID
AND MED.PLAN_ID = MD.PLAN_ID
AND MED.EXCEPTION_TYPE IN (13
, 14
, 24
, 26)