APPS.WMS_XDOCK_PEGGING_PUB dependencies on OE_DROP_SHIP_SOURCES

Line 1805: FROM oe_drop_ship_sources odss

1801: AND pod2.line_location_id = poll.line_location_id
1802: AND NVL(pod2.destination_type_code, pod2.destination_context) IN
1803: ('EXPENSE','SHOP FLOOR'))
1804: AND NOT EXISTS (SELECT 'Drop Ship'
1805: FROM oe_drop_ship_sources odss
1806: WHERE odss.po_header_id = poll.po_header_id
1807: AND odss.po_line_id = poll.po_line_id
1808: AND odss.line_location_id = poll.line_location_id)
1809: GROUP BY poll.po_header_id, poll.po_line_id, poll.line_location_id, muom.uom_code

Line 1858: FROM oe_drop_ship_sources odss

1854: AND pod2.line_location_id = poll.line_location_id
1855: AND NVL(pod2.destination_type_code, pod2.destination_context) IN
1856: ('EXPENSE','SHOP FLOOR'))
1857: AND NOT EXISTS (SELECT 'Drop Ship'
1858: FROM oe_drop_ship_sources odss
1859: WHERE odss.po_header_id = poll.po_header_id
1860: AND odss.po_line_id = poll.po_line_id
1861: AND odss.line_location_id = poll.line_location_id)
1862: GROUP BY rsl.po_header_id, rsl.po_line_location_id, rsl.shipment_line_id,

Line 6432: FROM oe_drop_ship_sources odss

6428: AND ool.booked_flag = 'Y'
6429: AND ool.open_flag = 'Y'
6430: AND NVL(ool.fulfillment_base,'P') <> 'S' --16466246
6431: AND NOT EXISTS (SELECT 'Drop Ship'
6432: FROM oe_drop_ship_sources odss
6433: WHERE odss.header_id = ool.header_id
6434: AND odss.line_id = ool.line_id)
6435: -- Only pick up WDD lines that match the project/task of the MOL if necessary
6436: AND (l_project_ref_enabled = 2 OR

Line 6467: FROM oe_drop_ship_sources odss

6463: AND ool.booked_flag = 'Y'
6464: AND ool.open_flag = 'Y'
6465: AND NVL(ool.fulfillment_base,'P') <> 'S' --16466246
6466: AND NOT EXISTS (SELECT 'Drop Ship'
6467: FROM oe_drop_ship_sources odss
6468: WHERE odss.header_id = ool.header_id
6469: AND odss.line_id = ool.line_id)
6470: -- Only pick up WDD lines that match the project/task of the MOL if necessary
6471: AND (l_project_ref_enabled = 2 OR

Line 6502: FROM oe_drop_ship_sources odss

6498: AND ool.booked_flag = 'Y'
6499: AND ool.open_flag = 'Y'
6500: AND NVL(ool.fulfillment_base,'P') <> 'S' --16466246
6501: AND NOT EXISTS (SELECT 'Drop Ship'
6502: FROM oe_drop_ship_sources odss
6503: WHERE odss.header_id = ool.header_id
6504: AND odss.line_id = ool.line_id)
6505: -- Only pick up WDD lines that match the project/task of the MOL if necessary
6506: AND (l_project_ref_enabled = 2 OR

Line 6537: FROM oe_drop_ship_sources odss

6533: AND ool.booked_flag = 'Y'
6534: AND ool.open_flag = 'Y'
6535: AND NVL(ool.fulfillment_base,'P') <> 'S' --16466246
6536: AND NOT EXISTS (SELECT 'Drop Ship'
6537: FROM oe_drop_ship_sources odss
6538: WHERE odss.header_id = ool.header_id
6539: AND odss.line_id = ool.line_id)
6540: -- Only pick up WDD lines that match the project/task of the MOL if necessary
6541: AND (l_project_ref_enabled = 2 OR

Line 6774: FROM oe_drop_ship_sources odss

6770: AND wdd.source_line_id = ool.line_id
6771: AND ool.booked_flag = 'Y'
6772: AND ool.open_flag = 'Y'
6773: AND NOT EXISTS (SELECT 'Drop Ship'
6774: FROM oe_drop_ship_sources odss
6775: WHERE odss.header_id = ool.header_id
6776: AND odss.line_id = ool.line_id)
6777: -- Only pick up WDD lines that match the project/task of the MOL if necessary
6778: AND (l_project_ref_enabled = 2 OR