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_INTEGRATION_PVT dependencies on RCV_LOTS_SUPPLY

Line 1374: rcv_lots_supply

1370: -- OPMConvergence
1371: ,l_sec_lot_qty
1372: -- OPMConvergence
1373: FROM
1374: rcv_lots_supply
1375: WHERE
1376: shipment_line_id = p_shipment_line_id
1377: AND supply_type_code = 'SHIPMENT'
1378: GROUP BY lot_num;

Line 1621: FROM rcv_lots_supply

1617: AND supply_type_code = 'SHIPMENT';
1618:
1619: SELECT Count(*)
1620: INTO l_lots_count
1621: FROM rcv_lots_supply
1622: WHERE shipment_line_id = p_shipment_line_id
1623: AND supply_type_code = 'SHIPMENT';
1624:
1625: IF (l_debug = 1) THEN

Line 1659: DELETE FROM rcv_lots_supply

1655: END IF;
1656:
1657: IF l_lots_count > 0 THEN
1658:
1659: DELETE FROM rcv_lots_supply
1660: WHERE shipment_line_id = p_shipment_line_id
1661: AND supply_type_code = 'SHIPMENT';
1662:
1663: END IF;

Line 11713: , rcv_lots_supply rls

11709: , NULL) inspection_status
11710: , rt.project_id project_id
11711: , rt.task_id task_id
11712: FROM rcv_supply rs
11713: , rcv_lots_supply rls
11714: , rcv_transactions rt
11715: WHERE rs.lpn_id = v_lpn_id
11716: AND rs.rcv_transaction_id = rls.transaction_id (+)
11717: AND rs.supply_type_code = 'RECEIVING'

Line 17136: FROM mtl_transaction_lots_interface mtli, rcv_lots_supply rls

17132: mtli.transaction_quantity,
17133: mtli.primary_quantity,
17134: mtli.serial_transaction_temp_id,
17135: mtli.ROWID
17136: FROM mtl_transaction_lots_interface mtli, rcv_lots_supply rls
17137: WHERE mtli.product_code = 'RCV'
17138: AND mtli.product_transaction_id = l_old_rti_id
17139: AND mtli.lot_number = rls.lot_num --14573375 removed outer join
17140: AND NVL(rls.shipment_line_id,l_shipment_line_id) = l_shipment_line_id

Line 18140: FROM rcv_lots_supply

18136: l_dummy VARCHAR2(1);
18137: BEGIN
18138: SELECT '1'
18139: INTO l_dummy
18140: FROM rcv_lots_supply
18141: WHERE transaction_id = p_parent_txn_id
18142: AND ROWNUM = 1;
18143:
18144: RETURN TRUE;

Line 19721: FROM rcv_lots_supply rls

19717: * So, added nvl for the SUM(rls.primary_quantity).
19718: */
19719: SELECT nvl(SUM(rls.primary_quantity),0)--Bug:5489462
19720: INTO L_RLS_PRIMARY_QUANTITY
19721: FROM rcv_lots_supply rls
19722: , rcv_shipment_lines rsl
19723: WHERE rsl.SHIPMENT_LINE_ID = rls.SHIPMENT_LINE_ID
19724: AND rsl.shipment_header_id = l_shipment_header_id
19725: --Bug 12348470 Reverted the fix 94466813

Line 19940: FROM rcv_lots_supply

19936: -- INVCONV , Remove sublot_num. Punit Kumar
19937:
19938: SELECT Sum(primary_quantity) -- Bug 14117094
19939: INTO l_rls_primary_quantity
19940: FROM rcv_lots_supply
19941: WHERE transaction_id = l_parent_transaction_id
19942: AND lot_num = Ltrim(Rtrim(l_mtlt_rec.lot_number)) ;
19943: /*
19944: AND ((sublot_num IS NULL and Ltrim(Rtrim(l_mtlt_rec.sublot_num)) IS NULL)

Line 20078: FROM rcv_lots_supply rls

20074: IF (L_FROM_ORG_LOT_CTRL = 2) THEN
20075: BEGIN
20076: SELECT nvl(SUM(rls.primary_quantity),0) --Bug:5489462
20077: INTO L_RLS_PRIMARY_QUANTITY
20078: FROM rcv_lots_supply rls
20079: , rcv_shipment_lines rsl
20080: WHERE rls.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
20081: AND rsl.shipment_header_id = l_shipment_header_id
20082: AND rsl.item_id = l_item_id

Line 24410: FROM rcv_lots_supply

24406:
24407: /*INVCONV, Remove the sublot no check in SQL */
24408: SELECT primary_quantity
24409: INTO l_rls_primary_quantity
24410: FROM rcv_lots_supply
24411: WHERE transaction_id = l_great_grand_parent_txn_id
24412: AND lot_num = Ltrim(Rtrim(l_mtlt_rec.lot_number)) ;
24413: /*AND ((sublot_num IS NULL and Ltrim(Rtrim(l_mtlt_rec.sublot_num)) IS NULL)
24414: OR (sublot_num = Ltrim(Rtrim(l_mtlt_rec.sublot_num)))) ;*/

Line 24555: FROM rcv_lots_supply

24551: /* INVCONV , Remove Sublot Num from SQL , Punit Kumar*/
24552:
24553: SELECT primary_quantity
24554: INTO l_rls_primary_quantity
24555: FROM rcv_lots_supply
24556: WHERE transaction_id = l_parent_transaction_id
24557: AND lot_num = Ltrim(Rtrim(l_mtlt_rec.lot_number));
24558:
24559: /* AND ((sublot_num IS NULL and Ltrim(Rtrim(l_mtlt_rec.sublot_num)) IS NULL)

Line 26815: FROM rcv_lots_supply

26811: /* INVCONV, Remove sublot Num , Punit Kumar */
26812:
26813: SELECT primary_quantity
26814: INTO l_rls_primary_quantity
26815: FROM rcv_lots_supply
26816: WHERE transaction_id = l_grand_parent_txn_id
26817: AND lot_num = Ltrim(Rtrim(l_mtlt_rec.lot_number)) ;
26818:
26819: /* AND ((sublot_num IS NULL and Ltrim(Rtrim(l_mtlt_rec.sublot_num)) IS NULL)

Line 27035: FROM rcv_lots_supply

27031: /*INVCONV , Remove Sublot Num , Punit Kumar*/
27032:
27033: SELECT primary_quantity
27034: INTO l_rls_primary_quantity
27035: FROM rcv_lots_supply
27036: WHERE transaction_id = l_grand_parent_txn_id
27037: AND lot_num = Ltrim(Rtrim(l_mtlt_rec.lot_number));
27038: /*
27039: AND ((sublot_num IS NULL and Ltrim(Rtrim(l_mtlt_rec.sublot_num)) IS NULL)

Line 27075: FROM rcv_lots_supply rls

27071: IF (L_FROM_ORG_LOT_CTRL = 2) THEN
27072: BEGIN
27073: SELECT nvl(SUM(rls.primary_quantity),0) --Bug:5489462
27074: INTO L_RLS_PRIMARY_QUANTITY
27075: FROM rcv_lots_supply rls
27076: , rcv_shipment_lines rsl
27077: WHERE rsl.SHIPMENT_LINE_ID = rls.SHIPMENT_LINE_ID
27078: AND rsl.shipment_header_id = l_shipment_header_id
27079: AND rsl.item_id = l_item_id