DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on WIP_LPN_COMPLETIONS

Line 7332: FROM wip_lpn_completions wlc, oe_order_lines_all ool

7328: BEGIN
7329: SELECT DECODE(ool.source_document_type_id, 10, 8, 2),
7330: wlc.demand_source_header_id, wlc.demand_source_line
7331: INTO l_wip_demand_type_id, l_wip_demand_header_id, l_wip_demand_line_id
7332: FROM wip_lpn_completions wlc, oe_order_lines_all ool
7333: WHERE wlc.header_id = l_mol_rec.reference_id
7334: -- MOL reference_id is link to header_id in WIP LPN Flow Completions table
7335: AND wlc.wip_entity_id = l_supply_header_id
7336: AND wlc.lpn_id = l_mol_lpn_id

Line 9646: -- Flow WIP LPN completions should not create reservations here. They are created

9642:
9643: -- Call the Create_RSV API to create a crossdock reservation.
9644: -- Do this only for OE demand, not WIP.
9645: -- For WIP supply, create a reservation only if the WIP entity type is 'Discrete'.
9646: -- Flow WIP LPN completions should not create reservations here. They are created
9647: -- immediately upon flow schedule completion against onhand Inventory.
9648: IF (l_demand_type_id <> 5 AND
9649: (l_wip_entity_type IS NULL OR l_wip_entity_type = 1)) THEN
9650: IF (l_debug = 1) THEN