APPS.WIP_WS_SHORTAGE dependencies on OE_DROP_SHIP_SOURCES

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

1461: AND pd.po_distribution_id = ms.po_distribution_id
1462: AND ms.po_line_id is not null
1463: AND ms.item_id is not null
1464: AND ms.to_org_primary_quantity > 0
1465: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1466: WHERE ms.po_line_location_id = ODSS.line_location_id);
1467:
1468: l_qty NUMBER := 0;
1469: BEGIN

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

1510: AND prl.requisition_line_id = ms.req_line_id
1511: AND ms.to_org_primary_quantity > 0
1512: AND ms.req_line_id is not null
1513: AND ms.item_id is not null
1514: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1515: WHERE ms.req_line_id = ODSS.requisition_line_id);
1516: l_qty NUMBER := 0;
1517: BEGIN
1518: for c_req_csr in req_csr(p_org_id, p_inv_item_id, p_rcpt_date) loop

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

1607: AND ms.req_line_id = pl.requisition_line_id
1608: AND ms.po_distribution_id is null
1609: AND ms.item_id is not null
1610: AND ms.to_org_primary_quantity > 0
1611: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1612: WHERE ms.req_line_id = ODSS.requisition_line_id)
1613: UNION ALL
1614: SELECT
1615: SUM(ms.to_org_primary_quantity) item_qty,

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

1670: AND trunc(ms.expected_delivery_date) = trunc(p_rcpt_date)
1671: AND pd.po_distribution_id = ms.po_distribution_id
1672: and ms.item_id is not null
1673: AND ms.to_org_primary_quantity > 0
1674: AND NOT EXISTS (select 'y' FROM OE_DROP_SHIP_SOURCES ODSS
1675: WHERE ms.po_line_location_id = ODSS.line_location_id);
1676: l_qty NUMBER := 0;
1677: BEGIN
1678: for c_po_rcv_csr in po_rcv_csr(p_org_id, p_inv_item_id, p_rcpt_date) loop