APPS.WMS_XDOCK_PEGGING_PUB dependencies on OE_DROP_SHIP_SOURCES

Line 1780: FROM oe_drop_ship_sources odss

1776: AND pod2.line_location_id = poll.line_location_id
1777: AND NVL(pod2.destination_type_code, pod2.destination_context) IN
1778: ('EXPENSE','SHOP FLOOR'))
1779: AND NOT EXISTS (SELECT 'Drop Ship'
1780: FROM oe_drop_ship_sources odss
1781: WHERE odss.po_header_id = poll.po_header_id
1782: AND odss.po_line_id = poll.po_line_id
1783: AND odss.line_location_id = poll.line_location_id)
1784: GROUP BY poll.po_header_id, poll.po_line_id, poll.line_location_id, muom.uom_code

Line 1833: FROM oe_drop_ship_sources odss

1829: AND pod2.line_location_id = poll.line_location_id
1830: AND NVL(pod2.destination_type_code, pod2.destination_context) IN
1831: ('EXPENSE','SHOP FLOOR'))
1832: AND NOT EXISTS (SELECT 'Drop Ship'
1833: FROM oe_drop_ship_sources odss
1834: WHERE odss.po_header_id = poll.po_header_id
1835: AND odss.po_line_id = poll.po_line_id
1836: AND odss.line_location_id = poll.line_location_id)
1837: GROUP BY rsl.po_header_id, rsl.po_line_location_id, rsl.shipment_line_id,

Line 6260: FROM oe_drop_ship_sources odss

6256: AND NVL(ool.source_document_type_id, -999) <> 10
6257: AND ool.booked_flag = 'Y'
6258: AND ool.open_flag = 'Y'
6259: AND NOT EXISTS (SELECT 'Drop Ship'
6260: FROM oe_drop_ship_sources odss
6261: WHERE odss.header_id = ool.header_id
6262: AND odss.line_id = ool.line_id)
6263: -- Only pick up WDD lines that match the project/task of the MOL if necessary
6264: AND (l_project_ref_enabled = 2 OR

Line 6294: FROM oe_drop_ship_sources odss

6290: AND NVL(ool.source_document_type_id, -999) <> 10
6291: AND ool.booked_flag = 'Y'
6292: AND ool.open_flag = 'Y'
6293: AND NOT EXISTS (SELECT 'Drop Ship'
6294: FROM oe_drop_ship_sources odss
6295: WHERE odss.header_id = ool.header_id
6296: AND odss.line_id = ool.line_id)
6297: -- Only pick up WDD lines that match the project/task of the MOL if necessary
6298: AND (l_project_ref_enabled = 2 OR

Line 6328: FROM oe_drop_ship_sources odss

6324: AND NVL(ool.source_document_type_id, -999) = 10
6325: AND ool.booked_flag = 'Y'
6326: AND ool.open_flag = 'Y'
6327: AND NOT EXISTS (SELECT 'Drop Ship'
6328: FROM oe_drop_ship_sources odss
6329: WHERE odss.header_id = ool.header_id
6330: AND odss.line_id = ool.line_id)
6331: -- Only pick up WDD lines that match the project/task of the MOL if necessary
6332: AND (l_project_ref_enabled = 2 OR

Line 6362: FROM oe_drop_ship_sources odss

6358: AND NVL(ool.source_document_type_id, -999) = 10
6359: AND ool.booked_flag = 'Y'
6360: AND ool.open_flag = 'Y'
6361: AND NOT EXISTS (SELECT 'Drop Ship'
6362: FROM oe_drop_ship_sources odss
6363: WHERE odss.header_id = ool.header_id
6364: AND odss.line_id = ool.line_id)
6365: -- Only pick up WDD lines that match the project/task of the MOL if necessary
6366: AND (l_project_ref_enabled = 2 OR

Line 6599: FROM oe_drop_ship_sources odss

6595: AND wdd.source_line_id = ool.line_id
6596: AND ool.booked_flag = 'Y'
6597: AND ool.open_flag = 'Y'
6598: AND NOT EXISTS (SELECT 'Drop Ship'
6599: FROM oe_drop_ship_sources odss
6600: WHERE odss.header_id = ool.header_id
6601: AND odss.line_id = ool.line_id)
6602: -- Only pick up WDD lines that match the project/task of the MOL if necessary
6603: AND (l_project_ref_enabled = 2 OR