DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on WIP_LPN_COMPLETIONS

Line 7157: FROM wip_lpn_completions wlc, oe_order_lines_all ool

7153: BEGIN
7154: SELECT DECODE(ool.source_document_type_id, 10, 8, 2),
7155: wlc.demand_source_header_id, wlc.demand_source_line
7156: INTO l_wip_demand_type_id, l_wip_demand_header_id, l_wip_demand_line_id
7157: FROM wip_lpn_completions wlc, oe_order_lines_all ool
7158: WHERE wlc.header_id = l_mol_rec.reference_id
7159: -- MOL reference_id is link to header_id in WIP LPN Flow Completions table
7160: AND wlc.wip_entity_id = l_supply_header_id
7161: AND wlc.lpn_id = l_mol_lpn_id

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

9448:
9449: -- Call the Create_RSV API to create a crossdock reservation.
9450: -- Do this only for OE demand, not WIP.
9451: -- For WIP supply, create a reservation only if the WIP entity type is 'Discrete'.
9452: -- Flow WIP LPN completions should not create reservations here. They are created
9453: -- immediately upon flow schedule completion against onhand Inventory.
9454: IF (l_demand_type_id <> 5 AND
9455: (l_wip_entity_type IS NULL OR l_wip_entity_type = 1)) THEN
9456: IF (l_debug = 1) THEN