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_SERIALS_SUPPLY

Line 1270: rcv_serials_supply

1266: BULK collect INTO
1267: l_serial_numbers
1268: ,l_lot_numbers
1269: FROM
1270: rcv_serials_supply
1271: WHERE
1272: shipment_line_id = p_shipment_line_id
1273: AND supply_type_code = 'SHIPMENT';
1274: EXCEPTION

Line 1615: FROM rcv_serials_supply

1611: END IF;
1612:
1613: SELECT Count(*)
1614: INTO l_serials_count
1615: FROM rcv_serials_supply
1616: WHERE shipment_line_id = p_shipment_line_id
1617: AND supply_type_code = 'SHIPMENT';
1618:
1619: SELECT Count(*)

Line 1641: FROM rcv_serials_supply

1637: lot_line_mark_id = NULL
1638: WHERE inventory_item_id = l_item_id
1639: AND current_organization_id = l_org_id
1640: AND serial_number IN (SELECT serial_num
1641: FROM rcv_serials_supply
1642: WHERE shipment_line_id = p_shipment_line_id
1643: AND supply_type_code = 'SHIPMENT')
1644: AND current_status = 5;
1645:

Line 1647: DELETE FROM rcv_serials_supply

1643: AND supply_type_code = 'SHIPMENT')
1644: AND current_status = 5;
1645:
1646:
1647: DELETE FROM rcv_serials_supply
1648: WHERE shipment_line_id = p_shipment_line_id
1649: AND supply_type_code = 'SHIPMENT';
1650: END IF;
1651:

Line 11720: FROM rcv_serials_supply rss

11716: AND rs.rcv_transaction_id = rls.transaction_id (+)
11717: AND rs.supply_type_code = 'RECEIVING'
11718: AND rs.rcv_transaction_id = rt.transaction_id
11719: AND NOT exists (SELECT 1
11720: FROM rcv_serials_supply rss
11721: WHERE rss.transaction_id = rs.rcv_transaction_id)
11722: UNION
11723: SELECT rs.rcv_transaction_id transaction_id
11724: , rs.item_id inventory_item_id

Line 11755: , rcv_serials_supply rss

11751: , NULL) inspection_status
11752: , rt.project_id project_id
11753: , rt.task_id task_id
11754: FROM rcv_supply rs
11755: , rcv_serials_supply rss
11756: , rcv_transactions rt
11757: WHERE rs.lpn_id = v_lpn_id
11758: AND rs.rcv_transaction_id = rss.transaction_id
11759: AND rs.supply_type_code = 'RECEIVING'

Line 17159: FROM mtl_serial_numbers_interface msni,rcv_serials_supply rss

17155: CURSOR msni_recs_with_rsl (l_old_rti_id NUMBER,l_shipment_line_id NUMBER) IS
17156: SELECT msni.fm_serial_number,
17157: msni.to_serial_number,
17158: msni.ROWID
17159: FROM mtl_serial_numbers_interface msni,rcv_serials_supply rss
17160: WHERE msni.product_code = 'RCV'
17161: AND msni.product_transaction_id = l_old_rti_id
17162: AND msni.fm_serial_number = rss.serial_num(+)
17163: AND NVL(rss.shipment_line_id,l_shipment_line_id) = l_shipment_line_id --10248599

Line 18121: FROM rcv_serials_supply

18117: l_dummy VARCHAR2(1);
18118: BEGIN
18119: SELECT '1'
18120: INTO l_dummy
18121: FROM rcv_serials_supply
18122: WHERE transaction_id = p_parent_txn_id
18123: AND ROWNUM = 1;
18124:
18125: RETURN TRUE;

Line 18160: FROM rcv_serials_supply rss

18156: l_dummy VARCHAR2(1);
18157: BEGIN
18158: SELECT '1'
18159: INTO l_dummy
18160: FROM rcv_serials_supply rss
18161: , rcv_shipment_lines rsl
18162: WHERE rss.shipment_line_id = rsl.shipment_line_id
18163: AND rsl.shipment_header_id = p_shipment_header_id
18164: AND rsl.item_id = p_item_id

Line 20616: FROM rcv_serials_supply rss

20612: IF (rss_exists(l_shipment_header_id,l_item_id)) THEN
20613: BEGIN
20614: SELECT '1'
20615: INTO l_dummy
20616: FROM rcv_serials_supply rss
20617: , rcv_shipment_lines rsl
20618: WHERE rss.shipment_line_id = rsl.shipment_line_id
20619: AND rsl.shipment_header_id = l_shipment_header_id
20620: AND rsl.item_id = l_item_id

Line 20746: FROM rcv_serials_supply rss

20742:
20743: BEGIN
20744: SELECT '1'
20745: INTO L_DUMMY
20746: FROM rcv_serials_supply rss
20747: , rcv_shipment_lines rsl
20748: WHERE rss.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
20749: AND rsl.shipment_header_id = l_shipment_header_id
20750: AND rsl.item_id = l_item_id

Line 21291: FROM RCV_SERIALS_SUPPLY

21287: ELSE --IF NOT L_SERIAL_ENTERED_ON_PARENT THEN
21288: BEGIN
21289: SELECT '1'
21290: INTO L_DUMMY
21291: FROM RCV_SERIALS_SUPPLY
21292: WHERE TRANSACTION_ID = L_PARENT_TRANSACTION_ID
21293: AND SERIAL_NUM = L_SERIAL_NUMBER;
21294:
21295: IF (l_curr_status <> 7) THEN

Line 21706: FROM rcv_serials_supply rss

21702: IF (rss_exists(l_shipment_header_id,l_item_id)) THEN
21703: BEGIN
21704: SELECT '1'
21705: INTO l_dummy
21706: FROM rcv_serials_supply rss
21707: , rcv_shipment_lines rsl
21708: WHERE rss.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
21709: AND rsl.shipment_header_id = l_shipment_header_id
21710: AND rsl.item_id = l_item_id

Line 21842: FROM rcv_serials_supply rss

21838:
21839: BEGIN
21840: SELECT '1'
21841: INTO L_DUMMY
21842: FROM rcv_serials_supply rss
21843: , rcv_shipment_lines rsl
21844: WHERE rss.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
21845: AND rsl.shipment_header_id = l_shipment_header_id
21846: AND rsl.item_id = l_item_id

Line 22399: FROM RCV_SERIALS_SUPPLY

22395: ELSE --IF NOT L_SERIAL_ENTERED_ON_PARENT THEN
22396: BEGIN
22397: SELECT '1'
22398: INTO L_DUMMY
22399: FROM RCV_SERIALS_SUPPLY
22400: WHERE TRANSACTION_ID = L_PARENT_TRANSACTION_ID
22401: AND SERIAL_NUM = L_SERIAL_NUMBER;
22402:
22403: IF (l_curr_status <> 7) THEN

Line 25472: FROM RCV_SERIALS_SUPPLY

25468: IF (serial_entered_on_parent(l_great_grand_parent_txn_id)) THEN
25469: BEGIN
25470: SELECT '1'
25471: INTO L_DUMMY
25472: FROM RCV_SERIALS_SUPPLY
25473: WHERE TRANSACTION_ID = l_great_grand_parent_txn_id
25474: AND SERIAL_NUM = L_SERIAL_NUMBER;
25475:
25476: IF (l_curr_status <> 7) THEN

Line 25677: FROM RCV_SERIALS_SUPPLY

25673: ELSE
25674: BEGIN
25675: SELECT '1'
25676: INTO L_DUMMY
25677: FROM RCV_SERIALS_SUPPLY
25678: WHERE TRANSACTION_ID = l_parent_transaction_id
25679: AND SERIAL_NUM = L_SERIAL_NUMBER;
25680:
25681: IF (l_curr_status <> 7) THEN

Line 26248: FROM RCV_SERIALS_SUPPLY

26244: IF (serial_entered_on_parent(l_great_grand_parent_txn_id)) THEN
26245: BEGIN
26246: SELECT '1'
26247: INTO L_DUMMY
26248: FROM RCV_SERIALS_SUPPLY
26249: WHERE TRANSACTION_ID = l_great_grand_parent_txn_id
26250: AND SERIAL_NUM = L_SERIAL_NUMBER;
26251:
26252: IF (l_curr_status <> 7) THEN

Line 26452: FROM RCV_SERIALS_SUPPLY

26448: ELSE
26449: BEGIN
26450: SELECT '1'
26451: INTO L_DUMMY
26452: FROM RCV_SERIALS_SUPPLY
26453: WHERE TRANSACTION_ID = l_parent_transaction_id
26454: AND SERIAL_NUM = L_SERIAL_NUMBER;
26455:
26456: IF (l_curr_status <> 7) THEN

Line 27497: FROM RCV_SERIALS_SUPPLY

27493: ELSE --IF (serial_entered_on_parent(l_grand_parent_txn_id)) THEN
27494: BEGIN
27495: SELECT '1'
27496: INTO L_DUMMY
27497: FROM RCV_SERIALS_SUPPLY
27498: WHERE TRANSACTION_ID = l_grand_parent_txn_id
27499: AND SERIAL_NUM = L_SERIAL_NUMBER;
27500:
27501: IF (l_curr_status <> 7) THEN

Line 27622: FROM RCV_SERIALS_SUPPLY

27618: IF (serial_entered_on_parent(l_grand_parent_txn_id)) THEN
27619: BEGIN
27620: SELECT '1'
27621: INTO L_DUMMY
27622: FROM RCV_SERIALS_SUPPLY
27623: WHERE TRANSACTION_ID = l_grand_parent_txn_id
27624: AND SERIAL_NUM = L_SERIAL_NUMBER;
27625:
27626: IF (l_curr_status <> 7) THEN

Line 27861: FROM rcv_serials_supply rss

27857:
27858: BEGIN
27859: SELECT '1'
27860: INTO L_DUMMY
27861: FROM rcv_serials_supply rss
27862: , rcv_shipment_lines rsl
27863: WHERE rss.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
27864: AND rsl.shipment_header_id = l_shipment_header_id
27865: AND rsl.item_id = l_item_id

Line 28436: FROM RCV_SERIALS_SUPPLY

28432: ELSE --IF (serial_entered_on_parent(l_grand_parent_txn_id)) THEN
28433: BEGIN
28434: SELECT '1'
28435: INTO L_DUMMY
28436: FROM RCV_SERIALS_SUPPLY
28437: WHERE TRANSACTION_ID = l_grand_parent_txn_id
28438: AND SERIAL_NUM = L_SERIAL_NUMBER;
28439:
28440: IF (l_curr_status <> 7) THEN

Line 28558: FROM RCV_SERIALS_SUPPLY

28554: IF (serial_entered_on_parent(l_grand_parent_txn_id)) THEN
28555: BEGIN
28556: SELECT '1'
28557: INTO L_DUMMY
28558: FROM RCV_SERIALS_SUPPLY
28559: WHERE TRANSACTION_ID = l_grand_parent_txn_id
28560: AND SERIAL_NUM = L_SERIAL_NUMBER;
28561:
28562: IF (l_curr_status <> 7) THEN

Line 28789: FROM rcv_serials_supply rss

28785:
28786: BEGIN
28787: SELECT '1'
28788: INTO L_DUMMY
28789: FROM rcv_serials_supply rss
28790: , rcv_shipment_lines rsl
28791: WHERE rss.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
28792: AND rsl.shipment_header_id = l_shipment_header_id
28793: AND rsl.item_id = l_item_id