APPS.WIP_WS_SHORTAGE dependencies on OE_DROP_SHIP_SOURCES

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

1532: AND pd.po_distribution_id = ms.po_distribution_id
1533: AND ms.po_line_id is not null
1534: AND ms.item_id is not null
1535: AND ms.to_org_primary_quantity > 0
1536: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1537: WHERE ms.po_line_location_id = ODSS.line_location_id);
1538:
1539: l_qty NUMBER := 0;
1540: BEGIN

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

1581: AND prl.requisition_line_id = ms.req_line_id
1582: AND ms.to_org_primary_quantity > 0
1583: AND ms.req_line_id is not null
1584: AND ms.item_id is not null
1585: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1586: WHERE ms.req_line_id = ODSS.requisition_line_id);
1587: l_qty NUMBER := 0;
1588: BEGIN
1589: for c_req_csr in req_csr(p_org_id, p_inv_item_id, p_rcpt_date) loop

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

1678: AND ms.req_line_id = pl.requisition_line_id
1679: AND ms.po_distribution_id is null
1680: AND ms.item_id is not null
1681: AND ms.to_org_primary_quantity > 0
1682: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1683: WHERE ms.req_line_id = ODSS.requisition_line_id)
1684: UNION ALL
1685: SELECT
1686: SUM(ms.to_org_primary_quantity) item_qty,

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

1741: AND trunc(ms.expected_delivery_date) = trunc(p_rcpt_date)
1742: AND pd.po_distribution_id = ms.po_distribution_id
1743: and ms.item_id is not null
1744: AND ms.to_org_primary_quantity > 0
1745: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1746: WHERE ms.po_line_location_id = ODSS.line_location_id);
1747: l_qty NUMBER := 0;
1748: BEGIN
1749: for c_po_rcv_csr in po_rcv_csr(p_org_id, p_inv_item_id, p_rcpt_date) loop