APPS.INV_RCV_TXN_INTERFACE dependencies on RCV_LOTS_SUPPLY

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

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

Line 1011: FROM rcv_lots_supply rls

1007: AND (
1008: v_lot_number IS NULL OR EXISTS
1009: (
1010: SELECT lot_num
1011: FROM rcv_lots_supply rls
1012: WHERE rls.transaction_id = rs.supply_source_id
1013: AND rls.lot_num = v_lot_number
1014: )
1015: )

Line 1111: FROM rcv_lots_supply rls

1107: AND (
1108: v_lot_number IS NULL OR EXISTS
1109: (
1110: SELECT lot_num
1111: FROM rcv_lots_supply rls
1112: WHERE rls.transaction_id = rs.supply_source_id
1113: AND rls.lot_num = v_lot_number
1114: )
1115: )

Line 1210: FROM rcv_lots_supply rls

1206: AND (
1207: v_lot_number IS NULL OR EXISTS
1208: (
1209: SELECT lot_num
1210: FROM rcv_lots_supply rls
1211: WHERE rls.transaction_id = rs.supply_source_id
1212: AND rls.lot_num = v_lot_number
1213: )
1214: )

Line 1297: FROM rcv_lots_supply rls

1293: AND (
1294: v_lot_number IS NULL OR EXISTS
1295: (
1296: SELECT lot_num
1297: FROM rcv_lots_supply rls
1298: WHERE rls.transaction_id = rs.supply_source_id
1299: AND rls.lot_num = v_lot_number
1300: )
1301: )

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

1766: END IF;
1767:
1768: /* FP-J Lot/Serial Support Enhancement
1769: * If WMS and PO patch levels are J or higher, then we need to:
1770: * a) Match the lot number with that in RCV_LOTS_SUPPLY for the
1771: * the parent transaction in RCV_SUPPLY if lot number is not NULL
1772: * b) Match the LPN being delivered with the LPN in the RCV_SUPPLY for
1773: * the parent transaction
1774: * c) Set the value of lot_number to the cursor from that in the cascaded table