VIEW: APPS.MSD_DEM_PLANNED_SHIPMENTS_V

Source

View Text - Preformatted

SELECT plans.plan_id plan_id, plans.compile_designator, msi.item_name, mtp.organization_code, using_requirement_quantity, using_assembly_demand_date FROM msc_demands dem, msc_plans plans, msc_trading_partners mtp, msc_system_items msi WHERE dem.plan_id = plans.plan_id and plans.plan_id <> -1 and msi.sr_instance_id = dem.sr_instance_id and msi.plan_id = -1 and msi.organization_id = dem.organization_id and msi.inventory_item_id = dem.inventory_item_id and msi.mrp_planning_code <> 6 and mtp.partner_type = 3 and mtp.sr_tp_id = msi.organization_id and nvl(mtp.company_id,-1) = -1 and mtp.sr_instance_id = msi.sr_instance_id and dem.origination_type = 1 and dem.organization_id <> nvl(dem.source_organization_id, -23453)

View Text - HTML Formatted

SELECT PLANS.PLAN_ID PLAN_ID
, PLANS.COMPILE_DESIGNATOR
, MSI.ITEM_NAME
, MTP.ORGANIZATION_CODE
, USING_REQUIREMENT_QUANTITY
, USING_ASSEMBLY_DEMAND_DATE
FROM MSC_DEMANDS DEM
, MSC_PLANS PLANS
, MSC_TRADING_PARTNERS MTP
, MSC_SYSTEM_ITEMS MSI
WHERE DEM.PLAN_ID = PLANS.PLAN_ID
AND PLANS.PLAN_ID <> -1
AND MSI.SR_INSTANCE_ID = DEM.SR_INSTANCE_ID
AND MSI.PLAN_ID = -1
AND MSI.ORGANIZATION_ID = DEM.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = DEM.INVENTORY_ITEM_ID
AND MSI.MRP_PLANNING_CODE <> 6
AND MTP.PARTNER_TYPE = 3
AND MTP.SR_TP_ID = MSI.ORGANIZATION_ID
AND NVL(MTP.COMPANY_ID
, -1) = -1
AND MTP.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND DEM.ORIGINATION_TYPE = 1
AND DEM.ORGANIZATION_ID <> NVL(DEM.SOURCE_ORGANIZATION_ID
, -23453)