eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_HORIZONTAL_PLAN_SC dependencies on OE_DROP_SHIP_SOURCES

Line 1071: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS

1067: AND NVL(msi.compile_designator,items.compile_designator) = items.compile_designator
1068: AND NVL(msi.organization_id,items.organization_id) = items.organization_id
1069: AND pd.destination_subinventory = msi.sub_inventory_code(+)
1070: AND NVL(msi.netting_type,1) = 1
1071: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1072: WHERE ms.po_line_location_id = ODSS.line_location_id)
1073: GROUP BY
1074: ms.item_id,
1075: ms.to_organization_id,

Line 1242: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS

1238: AND NVL(msi.compile_designator,items.compile_designator) = items.compile_designator
1239: AND NVL(msi.organization_id,items.organization_id) = items.organization_id
1240: AND prl.destination_subinventory = msi.sub_inventory_code(+)
1241: AND NVL(msi.netting_type,1) = 1
1242: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1243: WHERE ms.req_line_id = ODSS.requisition_line_id)
1244: GROUP BY
1245: ms.item_id,
1246: ms.to_organization_id,

Line 1301: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS

1297: AND NVL(msi.compile_designator,items.compile_designator) = items.compile_designator
1298: AND NVL(msi.organization_id,items.organization_id) = items.organization_id
1299: AND pl.destination_subinventory = msi.sub_inventory_code(+)
1300: AND NVL(msi.netting_type,1) = 1
1301: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1302: WHERE ms.req_line_id = ODSS.requisition_line_id)
1303: GROUP BY
1304: ms.item_id,
1305: ms.to_organization_id,

Line 1405: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS

1401: AND NVL(msi.compile_designator,items.compile_designator) = items.compile_designator
1402: AND NVL(msi.organization_id,items.organization_id) = items.organization_id
1403: AND pd.destination_subinventory = msi.sub_inventory_code(+)
1404: AND NVL(msi.netting_type,1) = 1
1405: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1406: WHERE ms.po_line_location_id = ODSS.line_location_id)
1407: GROUP BY
1408: ms.item_id,
1409: ms.to_organization_id,

Line 1464: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS

1460: AND NVL(msi.compile_designator,items.compile_designator) = items.compile_designator
1461: AND NVL(msi.organization_id,items.organization_id) = items.organization_id
1462: AND pd.destination_subinventory = msi.sub_inventory_code(+)
1463: AND NVL(msi.netting_type,1) = 1
1464: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1465: WHERE ms.po_line_location_id = ODSS.line_location_id)
1466: GROUP BY
1467: ms.item_id,
1468: ms.to_organization_id,

Line 1628: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS

1624: AND NVL(msi.compile_designator,items.compile_designator) = items.compile_designator
1625: AND NVL(msi.organization_id,items.organization_id) = items.organization_id
1626: AND ms.to_subinventory = msi.sub_inventory_code(+)
1627: AND NVL(msi.netting_type,1) = 1
1628: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1629: WHERE ms.req_line_id = ODSS.requisition_line_id)
1630: GROUP BY
1631: ms.item_id,
1632: ms.to_organization_id,