APPS.GMPMPACT dependencies on OE_DROP_SHIP_SOURCES

Line 598: ( SELECT 1 FROM oe_drop_ship_sources odss

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

Line 620: ( SELECT 1 FROM oe_drop_ship_sources odss

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

Line 643: ( SELECT 1 FROM oe_drop_ship_sources odss

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

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

940: ' AND nvl(hou.date_to,SYSDATE) >= SYSDATE '||
941: ' AND po.expected_delivery_date >= nvl(:start_date, po.expected_delivery_date - 1) '||
942: ' AND po.expected_delivery_date <= nvl(:end_date, po.expected_delivery_date + 1) '||
943: ' AND NOT EXISTS '||
944: ' ( SELECT 1 FROM oe_drop_ship_sources odss '||
945: ' WHERE po.po_header_id = odss.po_header_id '||
946: ' AND po.po_line_id = odss.po_line_id ) '||
947: ' UNION ALL '||
948: ' SELECT po.expected_delivery_date, '||''''||'PREQ'||''''||' , '||

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

972: ' AND po.expected_delivery_date >= nvl(:start_date, po.expected_delivery_date - 1) '||
973: ' AND po.expected_delivery_date <= nvl(:end_date, po.expected_delivery_date + 1) '||
974: ' AND nvl(hou.date_to,SYSDATE) >= SYSDATE '||
975: ' AND NOT EXISTS '||
976: ' ( SELECT 1 FROM oe_drop_ship_sources odss '||
977: ' WHERE po.REQUISITION_HEADER_ID = odss.REQUISITION_HEADER_ID '||
978: ' AND po.REQ_LINE_ID = odss.REQUISITION_LINE_ID ) '||
979: ' UNION ALL'||
980: ' SELECT po.expected_delivery_date trans_date, '||''''||'PRCV'||''''||' doc_type, '||

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

1004: ' AND po.expected_delivery_date >= nvl(:start_date, po.expected_delivery_date - 1) '||
1005: ' AND po.expected_delivery_date <= nvl(:end_date, po.expected_delivery_date + 1) '||
1006: ' AND nvl(hou.date_to,SYSDATE) >= SYSDATE '||
1007: ' AND NOT EXISTS '||
1008: ' ( SELECT 1 FROM oe_drop_ship_sources odss '||
1009: ' WHERE po.po_header_id = odss.po_header_id '||
1010: ' AND po.po_line_id = odss.po_line_id ) '||
1011: ' UNION ALL'||
1012: ' SELECT po.expected_delivery_date trans_date, '||''''||'PRCV'||''''||' doc_type ,'||

Line 1548: ( SELECT 1 FROM oe_drop_ship_sources odss

1544: -- AND ic.noninv_ind = 0
1545: -- AND ic.experimental_ind = 0
1546: -- AND ic.delete_mark = 0
1547: AND NOT EXISTS
1548: ( SELECT 1 FROM oe_drop_ship_sources odss
1549: WHERE po.PO_HEADER_ID = odss.PO_HEADER_ID
1550: AND po.PO_LINE_ID = odss.PO_LINE_ID )
1551: AND po.po_line_id = G_tranline_id ;
1552:

Line 1573: ( SELECT 1 FROM oe_drop_ship_sources odss

1569: -- AND ic.noninv_ind = 0
1570: -- AND ic.experimental_ind = 0
1571: -- AND ic.delete_mark = 0
1572: AND NOT EXISTS
1573: ( SELECT 1 FROM oe_drop_ship_sources odss
1574: WHERE po.PO_HEADER_ID = odss.PO_HEADER_ID
1575: AND po.PO_LINE_ID = odss.PO_LINE_ID )
1576: AND po.po_line_id = G_tranline_id
1577: AND G_doc_type = 'PRCV'

Line 1647: ( SELECT 1 FROM oe_drop_ship_sources odss

1643: -- AND ic.experimental_ind = 0
1644: -- AND ic.delete_mark = 0
1645: -- AND iwm.orgn_code = G_orgn_code
1646: AND NOT EXISTS
1647: ( SELECT 1 FROM oe_drop_ship_sources odss
1648: WHERE po.REQUISITION_HEADER_ID = odss.REQUISITION_HEADER_ID
1649: AND po.REQ_LINE_ID = odss.REQUISITION_LINE_ID )
1650: AND po.req_line_id = G_tranline_id ;
1651: