APPS.GMPMPACT dependencies on OE_DROP_SHIP_SOURCES

Line 596: ( SELECT 1 FROM oe_drop_ship_sources odss

592: -- AND ic.noninv_ind = 0
593: -- AND ic.experimental_ind = 0
594: -- AND ic.delete_mark = 0
595: AND NOT EXISTS
596: ( SELECT 1 FROM oe_drop_ship_sources odss
597: WHERE po.PO_HEADER_ID = odss.PO_HEADER_ID
598: AND po.PO_LINE_ID = odss.PO_LINE_ID )
599: AND po.po_header_id = G_doc_id ;
600:

Line 618: ( SELECT 1 FROM oe_drop_ship_sources odss

614: -- AND ic.noninv_ind = 0
615: -- AND ic.experimental_ind = 0
616: -- AND ic.delete_mark = 0
617: AND NOT EXISTS
618: ( SELECT 1 FROM oe_drop_ship_sources odss
619: WHERE po.REQUISITION_HEADER_ID = odss.REQUISITION_HEADER_ID
620: AND po.REQ_LINE_ID = odss.REQUISITION_LINE_ID )
621: AND po.requisition_header_id = G_doc_id ;
622:

Line 641: ( SELECT 1 FROM oe_drop_ship_sources odss

637: -- AND ic.experimental_ind = 0
638: -- AND ic.delete_mark = 0
639: AND po.po_header_id = ph.po_header_id
640: AND NOT EXISTS
641: ( SELECT 1 FROM oe_drop_ship_sources odss
642: WHERE po.PO_HEADER_ID = odss.PO_HEADER_ID
643: AND po.PO_LINE_ID = odss.PO_LINE_ID )
644: AND po.po_header_id = G_doc_id
645: AND G_doc_type = 'PRCV'

Line 938: ' ( SELECT 1 FROM oe_drop_ship_sources odss '||

934: ' AND nvl(hou.date_to,SYSDATE) >= SYSDATE '||
935: ' AND po.expected_delivery_date >= nvl(:start_date, po.expected_delivery_date - 1) '||
936: ' AND po.expected_delivery_date <= nvl(:end_date, po.expected_delivery_date + 1) '||
937: ' AND NOT EXISTS '||
938: ' ( SELECT 1 FROM oe_drop_ship_sources odss '||
939: ' WHERE po.po_header_id = odss.po_header_id '||
940: ' AND po.po_line_id = odss.po_line_id ) '||
941: ' UNION ALL '||
942: ' SELECT po.expected_delivery_date, '||''''||'PREQ'||''''||' , '||

Line 970: ' ( SELECT 1 FROM oe_drop_ship_sources odss '||

966: ' AND po.expected_delivery_date >= nvl(:start_date, po.expected_delivery_date - 1) '||
967: ' AND po.expected_delivery_date <= nvl(:end_date, po.expected_delivery_date + 1) '||
968: ' AND nvl(hou.date_to,SYSDATE) >= SYSDATE '||
969: ' AND NOT EXISTS '||
970: ' ( SELECT 1 FROM oe_drop_ship_sources odss '||
971: ' WHERE po.REQUISITION_HEADER_ID = odss.REQUISITION_HEADER_ID '||
972: ' AND po.REQ_LINE_ID = odss.REQUISITION_LINE_ID ) '||
973: ' UNION ALL'||
974: ' SELECT po.expected_delivery_date trans_date, '||''''||'PRCV'||''''||' doc_type, '||

Line 1002: ' ( SELECT 1 FROM oe_drop_ship_sources odss '||

998: ' AND po.expected_delivery_date >= nvl(:start_date, po.expected_delivery_date - 1) '||
999: ' AND po.expected_delivery_date <= nvl(:end_date, po.expected_delivery_date + 1) '||
1000: ' AND nvl(hou.date_to,SYSDATE) >= SYSDATE '||
1001: ' AND NOT EXISTS '||
1002: ' ( SELECT 1 FROM oe_drop_ship_sources odss '||
1003: ' WHERE po.po_header_id = odss.po_header_id '||
1004: ' AND po.po_line_id = odss.po_line_id ) '||
1005: ' UNION ALL'||
1006: ' SELECT po.expected_delivery_date trans_date, '||''''||'PRCV'||''''||' doc_type ,'||

Line 1540: ( SELECT 1 FROM oe_drop_ship_sources odss

1536: -- AND ic.noninv_ind = 0
1537: -- AND ic.experimental_ind = 0
1538: -- AND ic.delete_mark = 0
1539: AND NOT EXISTS
1540: ( SELECT 1 FROM oe_drop_ship_sources odss
1541: WHERE po.PO_HEADER_ID = odss.PO_HEADER_ID
1542: AND po.PO_LINE_ID = odss.PO_LINE_ID )
1543: AND po.po_line_id = G_tranline_id ;
1544:

Line 1563: ( SELECT 1 FROM oe_drop_ship_sources odss

1559: -- AND ic.noninv_ind = 0
1560: -- AND ic.experimental_ind = 0
1561: -- AND ic.delete_mark = 0
1562: AND NOT EXISTS
1563: ( SELECT 1 FROM oe_drop_ship_sources odss
1564: WHERE po.PO_HEADER_ID = odss.PO_HEADER_ID
1565: AND po.PO_LINE_ID = odss.PO_LINE_ID )
1566: AND po.po_line_id = G_tranline_id
1567: AND G_doc_type = 'PRCV'

Line 1633: ( SELECT 1 FROM oe_drop_ship_sources odss

1629: -- AND ic.experimental_ind = 0
1630: -- AND ic.delete_mark = 0
1631: -- AND iwm.orgn_code = G_orgn_code
1632: AND NOT EXISTS
1633: ( SELECT 1 FROM oe_drop_ship_sources odss
1634: WHERE po.REQUISITION_HEADER_ID = odss.REQUISITION_HEADER_ID
1635: AND po.REQ_LINE_ID = odss.REQUISITION_LINE_ID )
1636: AND po.req_line_id = G_tranline_id ;
1637: