eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_TXN_MATCH dependencies on RCV_LOTS_SUPPLY

Line 398: FROM rcv_lots_supply rls

394: OR
395: EXISTS
396: (
397: SELECT lot_num
398: FROM rcv_lots_supply rls
399: WHERE rls.shipment_line_id = rsl.shipment_line_id
400: AND rls.lot_num = v_lot_number
401: AND rls.supply_type_code = 'SHIPMENT'
402: )

Line 513: FROM rcv_lots_supply rls

509: OR
510: EXISTS
511: (
512: SELECT lot_num
513: FROM rcv_lots_supply rls
514: WHERE rls.shipment_line_id = rsl.shipment_line_id
515: AND rls.lot_num = v_lot_number
516: AND rls.supply_type_code = 'SHIPMENT'
517: )

Line 1005: FROM rcv_lots_supply rls

1001: WHERE inventory_item_id = v_item_id
1002: AND LOT_CONTROL_CODE = 1
1003: AND ORGANIZATION_ID = rsl.FROM_ORGANIZATION_ID )
1004: OR EXISTS (SELECT lot_num
1005: FROM rcv_lots_supply rls
1006: WHERE rls.shipment_line_id = rsl.shipment_line_id
1007: AND rls.lot_num = v_lot_number
1008: AND rls.supply_type_code = 'SHIPMENT')
1009: )

Line 1102: FROM rcv_lots_supply rls

1098: WHERE inventory_item_id = v_item_id
1099: AND LOT_CONTROL_CODE = 1
1100: AND ORGANIZATION_ID = rsl.FROM_ORGANIZATION_ID )
1101: OR EXISTS (SELECT lot_num
1102: FROM rcv_lots_supply rls
1103: WHERE rls.shipment_line_id = rsl.shipment_line_id
1104: AND rls.lot_num = v_lot_number
1105: AND rls.supply_type_code = 'SHIPMENT')
1106: )

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

1218: AND Nvl(oel.ship_from_org_id, oeh.ship_from_org_id) = v_org_id; --added for bug 3578489
1219:
1220: /* FP-J Lot/Serial Support Enhancement
1221: * Added two new arguments to the cursor, v_lot_number and v_lpn_id_to_match
1222: * Added conditions to match the lot number with that in RCV_LOTS_SUPPLY
1223: * and the LPN with that in RCV_SUPPLY for the parent trasnaction
1224: * This would be done only if WMS and PO patchset levels are J or higher
1225: */
1226:

Line 1307: FROM rcv_lots_supply rls

1303: OR EXISTS
1304: (
1305: --Bug 13400589 Modified the below condition which will handle the case for non wms orgs.
1306: SELECT lot_num
1307: FROM rcv_lots_supply rls
1308: WHERE ( rls.transaction_id = rsup.supply_source_id
1309: OR (rls.transaction_id IS NULL
1310: AND rls.shipment_Line_Id=rsup.shipment_line_id))
1311: AND rls.lot_num = v_lot_number

Line 1388: FROM rcv_lots_supply rls

1384: OR EXISTS
1385: (
1386: --Bug 13400589 Modified the below condition which will handle the case for non wms orgs.
1387: SELECT lot_num
1388: FROM rcv_lots_supply rls
1389: WHERE ( rls.transaction_id = rsup.supply_source_id
1390: OR (rls.transaction_id IS NULL
1391: AND rls.shipment_Line_Id=rsup.shipment_line_id))
1392: AND rls.lot_num = v_lot_number

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

1403: ) ;
1404:
1405: /* FP-J Lot/Serial Support Enhancement
1406: * Added two new arguments to the cursor, v_lot_number and v_lpn_id_to_match
1407: * Added conditions to match the lot number with that in RCV_LOTS_SUPPLY
1408: * and the LPN with that in RCV_SUPPLY for the parent trasnaction
1409: * This would be done only if WMS and PO patchset levels are J or higher
1410: */
1411: CURSOR rma_delivery_lines(

Line 1481: FROM rcv_lots_supply rls

1477: AND (
1478: v_lot_number IS NULL OR EXISTS
1479: (
1480: SELECT lot_num
1481: FROM rcv_lots_supply rls
1482: WHERE rls.transaction_id = rsup.supply_source_id
1483: AND rls.lot_num = v_lot_number
1484: )
1485: )

Line 1550: FROM rcv_lots_supply rls

1546: AND (
1547: v_lot_number IS NULL OR EXISTS
1548: (
1549: SELECT lot_num
1550: FROM rcv_lots_supply rls
1551: WHERE rls.transaction_id = rsup.supply_source_id
1552: AND rls.lot_num = v_lot_number
1553: )
1554: )

Line 1647: FROM rcv_lots_supply rls

1643: AND (
1644: v_lot_number IS NULL OR EXISTS
1645: (
1646: SELECT lot_num
1647: FROM rcv_lots_supply rls
1648: WHERE rls.transaction_id = rsup.supply_source_id
1649: AND rls.lot_num = v_lot_number
1650: )
1651: )

Line 1728: FROM rcv_lots_supply rls

1724: AND (
1725: v_lot_number IS NULL OR EXISTS
1726: (
1727: SELECT lot_num
1728: FROM rcv_lots_supply rls
1729: WHERE rls.transaction_id = rsup.supply_source_id
1730: AND rls.lot_num = v_lot_number
1731: )
1732: )

Line 1821: FROM rcv_lots_supply rls

1817: AND (
1818: v_lot_number IS NULL OR EXISTS
1819: (
1820: SELECT lot_num
1821: FROM rcv_lots_supply rls
1822: WHERE rls.transaction_id = rsup.supply_source_id
1823: AND rls.lot_num = v_lot_number
1824: )
1825: )

Line 1898: FROM rcv_lots_supply rls

1894: AND (
1895: v_lot_number IS NULL OR EXISTS
1896: (
1897: SELECT lot_num
1898: FROM rcv_lots_supply rls
1899: WHERE rls.transaction_id = rsup.supply_source_id
1900: AND rls.lot_num = v_lot_number
1901: )
1902: )

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

2292: l_progress := '40';
2293:
2294: /* FP-J Lot/Serial Support Enhancement
2295: * If WMS and PO patch levels are J or higher, then we need to:
2296: * a) Match the lot number with that in RCV_LOTS_SUPPLY for the
2297: * the parent transaction in RCV_SUPPLY if lot number is not NULL
2298: * b) Match the LPN being delivered with the LPN in the RCV_SUPPLY for
2299: * the parent transaction
2300: * c) Set the value of lot_number to the cursor from that in the cascaded table