APPS.INV_RCV_TXN_INTERFACE dependencies on RCV_LOTS_SUPPLY

Line 904: * Added conditions to match the lot number with that in RCV_LOTS_SUPPLY

900:
901: ----
902: /* FP-J Lot/Serial Support Enhancement
903: * Added two new arguments to the cursor, v_lot_number and v_lpn_id_to_match
904: * Added conditions to match the lot number with that in RCV_LOTS_SUPPLY
905: * and the LPN with that in RCV_SUPPLY for the parent trasnaction
906: * This would be done only if WMS and PO patchset levels are J or higher
907: */
908: CURSOR std_distributions (

Line 1005: FROM rcv_lots_supply rls

1001: AND (
1002: v_lot_number IS NULL OR EXISTS
1003: (
1004: SELECT lot_num
1005: FROM rcv_lots_supply rls
1006: WHERE rls.transaction_id = rs.supply_source_id
1007: AND rls.lot_num = v_lot_number
1008: )
1009: )

Line 1105: FROM rcv_lots_supply rls

1101: AND (
1102: v_lot_number IS NULL OR EXISTS
1103: (
1104: SELECT lot_num
1105: FROM rcv_lots_supply rls
1106: WHERE rls.transaction_id = rs.supply_source_id
1107: AND rls.lot_num = v_lot_number
1108: )
1109: )

Line 1204: FROM rcv_lots_supply rls

1200: AND (
1201: v_lot_number IS NULL OR EXISTS
1202: (
1203: SELECT lot_num
1204: FROM rcv_lots_supply rls
1205: WHERE rls.transaction_id = rs.supply_source_id
1206: AND rls.lot_num = v_lot_number
1207: )
1208: )

Line 1291: FROM rcv_lots_supply rls

1287: AND (
1288: v_lot_number IS NULL OR EXISTS
1289: (
1290: SELECT lot_num
1291: FROM rcv_lots_supply rls
1292: WHERE rls.transaction_id = rs.supply_source_id
1293: AND rls.lot_num = v_lot_number
1294: )
1295: )

Line 1734: * a) Match the lot number with that in RCV_LOTS_SUPPLY for the

1730: END IF;
1731:
1732: /* FP-J Lot/Serial Support Enhancement
1733: * If WMS and PO patch levels are J or higher, then we need to:
1734: * a) Match the lot number with that in RCV_LOTS_SUPPLY for the
1735: * the parent transaction in RCV_SUPPLY if lot number is not NULL
1736: * b) Match the LPN being delivered with the LPN in the RCV_SUPPLY for
1737: * the parent transaction
1738: * c) Set the value of lot_number to the cursor from that in the cascaded table