APPS.WIP_SO_RESERVATIONS dependencies on WIP_LPN_COMPLETIONS

Line 97: ELSE -- get lines from wip_lpn_completions table

93: p_transaction_type => WIP_CONSTANTS.WASSY_COMPLETION,
94: p_txn_temp_id => p_txn_temp_id,
95: x_return_status => l_return_status,
96: x_transaction_tbl => l_transaction_tbl);
97: ELSE -- get lines from wip_lpn_completions table
98: get_transaction_lines(
99: p_header_id => p_transaction_header_id,
100: p_primary_quantity => p_primary_quantity,
101: p_lpn_id => p_lpn_id,

Line 1521: -- wip_lpn_completions

1517: --
1518: -- PROCEDURE get_transaction_lines
1519: --
1520: -- This procedure returns a table of transaction records from
1521: -- wip_lpn_completions
1522: -- Used to match with reservation.
1523: --
1524: --
1525: -- Internal helper

Line 1561: WIP_LPN_COMPLETIONS_LOTS WLCL,

1557: WLCL.lot_expiration_date,
1558: null,
1559: p_lpn_id
1560: FROM MTL_SYSTEM_ITEMS MSI,
1561: WIP_LPN_COMPLETIONS_LOTS WLCL,
1562: WIP_LPN_COMPLETIONS WLC
1563: WHERE wlc.header_id = cp_header_id
1564: AND wlc.transaction_source_type_id = 5 /* Job or Schedule */
1565: AND wlcl.header_id (+) = wlc.header_id

Line 1562: WIP_LPN_COMPLETIONS WLC

1558: null,
1559: p_lpn_id
1560: FROM MTL_SYSTEM_ITEMS MSI,
1561: WIP_LPN_COMPLETIONS_LOTS WLCL,
1562: WIP_LPN_COMPLETIONS WLC
1563: WHERE wlc.header_id = cp_header_id
1564: AND wlc.transaction_source_type_id = 5 /* Job or Schedule */
1565: AND wlcl.header_id (+) = wlc.header_id
1566: AND wlcl.lot_number (+) = p_lot_number