APPS.INV_RCV_TXN_MATCH dependencies on RCV_LOTS_SUPPLY

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

1046: AND Nvl(oel.ship_from_org_id, oeh.ship_from_org_id) = v_org_id; --added for bug 3578489
1047:
1048: /* FP-J Lot/Serial Support Enhancement
1049: * Added two new arguments to the cursor, v_lot_number and v_lpn_id_to_match
1050: * Added conditions to match the lot number with that in RCV_LOTS_SUPPLY
1051: * and the LPN with that in RCV_SUPPLY for the parent trasnaction
1052: * This would be done only if WMS and PO patchset levels are J or higher
1053: */
1054:

Line 1128: FROM rcv_lots_supply rls

1124: AND (
1125: v_lot_number IS NULL OR EXISTS
1126: (
1127: SELECT lot_num
1128: FROM rcv_lots_supply rls
1129: WHERE rls.transaction_id = rsup.supply_source_id
1130: AND rls.lot_num = v_lot_number
1131: )
1132: )

Line 1200: FROM rcv_lots_supply rls

1196: AND (
1197: v_lot_number IS NULL OR EXISTS
1198: (
1199: SELECT lot_num
1200: FROM rcv_lots_supply rls
1201: WHERE rls.transaction_id = rsup.supply_source_id
1202: AND rls.lot_num = v_lot_number
1203: )
1204: )

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

1212: ) ;
1213:
1214: /* FP-J Lot/Serial Support Enhancement
1215: * Added two new arguments to the cursor, v_lot_number and v_lpn_id_to_match
1216: * Added conditions to match the lot number with that in RCV_LOTS_SUPPLY
1217: * and the LPN with that in RCV_SUPPLY for the parent trasnaction
1218: * This would be done only if WMS and PO patchset levels are J or higher
1219: */
1220: CURSOR rma_delivery_lines(

Line 1290: FROM rcv_lots_supply rls

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

Line 1359: FROM rcv_lots_supply rls

1355: AND (
1356: v_lot_number IS NULL OR EXISTS
1357: (
1358: SELECT lot_num
1359: FROM rcv_lots_supply rls
1360: WHERE rls.transaction_id = rsup.supply_source_id
1361: AND rls.lot_num = v_lot_number
1362: )
1363: )

Line 1454: FROM rcv_lots_supply rls

1450: AND (
1451: v_lot_number IS NULL OR EXISTS
1452: (
1453: SELECT lot_num
1454: FROM rcv_lots_supply rls
1455: WHERE rls.transaction_id = rsup.supply_source_id
1456: AND rls.lot_num = v_lot_number
1457: )
1458: )

Line 1531: FROM rcv_lots_supply rls

1527: AND (
1528: v_lot_number IS NULL OR EXISTS
1529: (
1530: SELECT lot_num
1531: FROM rcv_lots_supply rls
1532: WHERE rls.transaction_id = rsup.supply_source_id
1533: AND rls.lot_num = v_lot_number
1534: )
1535: )

Line 1624: FROM rcv_lots_supply rls

1620: AND (
1621: v_lot_number IS NULL OR EXISTS
1622: (
1623: SELECT lot_num
1624: FROM rcv_lots_supply rls
1625: WHERE rls.transaction_id = rsup.supply_source_id
1626: AND rls.lot_num = v_lot_number
1627: )
1628: )

Line 1701: FROM rcv_lots_supply rls

1697: AND (
1698: v_lot_number IS NULL OR EXISTS
1699: (
1700: SELECT lot_num
1701: FROM rcv_lots_supply rls
1702: WHERE rls.transaction_id = rsup.supply_source_id
1703: AND rls.lot_num = v_lot_number
1704: )
1705: )

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

2065: l_progress := '40';
2066:
2067: /* FP-J Lot/Serial Support Enhancement
2068: * If WMS and PO patch levels are J or higher, then we need to:
2069: * a) Match the lot number with that in RCV_LOTS_SUPPLY for the
2070: * the parent transaction in RCV_SUPPLY if lot number is not NULL
2071: * b) Match the LPN being delivered with the LPN in the RCV_SUPPLY for
2072: * the parent transaction
2073: * c) Set the value of lot_number to the cursor from that in the cascaded table