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 1246: rcv_serials_supply

1242: BULK collect INTO
1243: l_serial_numbers
1244: ,l_lot_numbers
1245: FROM
1246: rcv_serials_supply
1247: WHERE
1248: shipment_line_id = p_shipment_line_id
1249: AND supply_type_code = 'SHIPMENT';
1250: EXCEPTION

Line 1591: FROM rcv_serials_supply

1587: END IF;
1588:
1589: SELECT Count(*)
1590: INTO l_serials_count
1591: FROM rcv_serials_supply
1592: WHERE shipment_line_id = p_shipment_line_id
1593: AND supply_type_code = 'SHIPMENT';
1594:
1595: SELECT Count(*)

Line 1616: FROM rcv_serials_supply

1612: lot_line_mark_id = NULL
1613: WHERE inventory_item_id = l_item_id
1614: AND current_organization_id = l_org_id
1615: AND serial_number IN (SELECT serial_number
1616: FROM rcv_serials_supply
1617: WHERE shipment_line_id = p_shipment_line_id
1618: AND supply_type_code = 'SHIPMENT')
1619: AND current_status = 5;
1620:

Line 1622: DELETE FROM rcv_serials_supply

1618: AND supply_type_code = 'SHIPMENT')
1619: AND current_status = 5;
1620:
1621:
1622: DELETE FROM rcv_serials_supply
1623: WHERE shipment_line_id = p_shipment_line_id
1624: AND supply_type_code = 'SHIPMENT';
1625: END IF;
1626:

Line 11243: FROM rcv_serials_supply rss

11239: AND rs.rcv_transaction_id = rls.transaction_id (+)
11240: AND rs.supply_type_code = 'RECEIVING'
11241: AND rs.rcv_transaction_id = rt.transaction_id
11242: AND NOT exists (SELECT 1
11243: FROM rcv_serials_supply rss
11244: WHERE rss.transaction_id = rs.rcv_transaction_id)
11245: UNION
11246: SELECT rs.rcv_transaction_id transaction_id
11247: , rs.item_id inventory_item_id

Line 11278: , rcv_serials_supply rss

11274: , NULL) inspection_status
11275: , rt.project_id project_id
11276: , rt.task_id task_id
11277: FROM rcv_supply rs
11278: , rcv_serials_supply rss
11279: , rcv_transactions rt
11280: WHERE rs.lpn_id = v_lpn_id
11281: AND rs.rcv_transaction_id = rss.transaction_id
11282: AND rs.supply_type_code = 'RECEIVING'

Line 17207: FROM rcv_serials_supply

17203: l_dummy VARCHAR2(1);
17204: BEGIN
17205: SELECT '1'
17206: INTO l_dummy
17207: FROM rcv_serials_supply
17208: WHERE transaction_id = p_parent_txn_id
17209: AND ROWNUM = 1;
17210:
17211: RETURN TRUE;

Line 17246: FROM rcv_serials_supply rss

17242: l_dummy VARCHAR2(1);
17243: BEGIN
17244: SELECT '1'
17245: INTO l_dummy
17246: FROM rcv_serials_supply rss
17247: , rcv_shipment_lines rsl
17248: WHERE rss.shipment_line_id = rsl.shipment_line_id
17249: AND rsl.shipment_header_id = p_shipment_header_id
17250: AND rsl.item_id = p_item_id

Line 19457: FROM rcv_serials_supply rss

19453: IF (rss_exists(l_shipment_header_id,l_item_id)) THEN
19454: BEGIN
19455: SELECT '1'
19456: INTO l_dummy
19457: FROM rcv_serials_supply rss
19458: , rcv_shipment_lines rsl
19459: WHERE rss.shipment_line_id = rsl.shipment_line_id
19460: AND rsl.shipment_header_id = l_shipment_header_id
19461: AND rsl.item_id = l_item_id

Line 19587: FROM rcv_serials_supply rss

19583:
19584: BEGIN
19585: SELECT '1'
19586: INTO L_DUMMY
19587: FROM rcv_serials_supply rss
19588: , rcv_shipment_lines rsl
19589: WHERE rss.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
19590: AND rsl.shipment_header_id = l_shipment_header_id
19591: AND rsl.item_id = l_item_id

Line 20130: FROM RCV_SERIALS_SUPPLY

20126: ELSE --IF NOT L_SERIAL_ENTERED_ON_PARENT THEN
20127: BEGIN
20128: SELECT '1'
20129: INTO L_DUMMY
20130: FROM RCV_SERIALS_SUPPLY
20131: WHERE TRANSACTION_ID = L_PARENT_TRANSACTION_ID
20132: AND SERIAL_NUM = L_SERIAL_NUMBER;
20133:
20134: IF (l_curr_status <> 7) THEN

Line 20511: FROM rcv_serials_supply rss

20507: IF (rss_exists(l_shipment_header_id,l_item_id)) THEN
20508: BEGIN
20509: SELECT '1'
20510: INTO l_dummy
20511: FROM rcv_serials_supply rss
20512: , rcv_shipment_lines rsl
20513: WHERE rss.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
20514: AND rsl.shipment_header_id = l_shipment_header_id
20515: AND rsl.item_id = l_item_id

Line 20647: FROM rcv_serials_supply rss

20643:
20644: BEGIN
20645: SELECT '1'
20646: INTO L_DUMMY
20647: FROM rcv_serials_supply rss
20648: , rcv_shipment_lines rsl
20649: WHERE rss.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
20650: AND rsl.shipment_header_id = l_shipment_header_id
20651: AND rsl.item_id = l_item_id

Line 21202: FROM RCV_SERIALS_SUPPLY

21198: ELSE --IF NOT L_SERIAL_ENTERED_ON_PARENT THEN
21199: BEGIN
21200: SELECT '1'
21201: INTO L_DUMMY
21202: FROM RCV_SERIALS_SUPPLY
21203: WHERE TRANSACTION_ID = L_PARENT_TRANSACTION_ID
21204: AND SERIAL_NUM = L_SERIAL_NUMBER;
21205:
21206: IF (l_curr_status <> 7) THEN

Line 24642: FROM RCV_SERIALS_SUPPLY

24638: IF (serial_entered_on_parent(l_great_grand_parent_txn_id)) THEN
24639: BEGIN
24640: SELECT '1'
24641: INTO L_DUMMY
24642: FROM RCV_SERIALS_SUPPLY
24643: WHERE TRANSACTION_ID = l_great_grand_parent_txn_id
24644: AND SERIAL_NUM = L_SERIAL_NUMBER;
24645:
24646: IF (l_curr_status <> 7) THEN

Line 24854: FROM RCV_SERIALS_SUPPLY

24850: ELSE
24851: BEGIN
24852: SELECT '1'
24853: INTO L_DUMMY
24854: FROM RCV_SERIALS_SUPPLY
24855: WHERE TRANSACTION_ID = l_parent_transaction_id
24856: AND SERIAL_NUM = L_SERIAL_NUMBER;
24857:
24858: IF (l_curr_status <> 7) THEN

Line 25406: FROM RCV_SERIALS_SUPPLY

25402: IF (serial_entered_on_parent(l_great_grand_parent_txn_id)) THEN
25403: BEGIN
25404: SELECT '1'
25405: INTO L_DUMMY
25406: FROM RCV_SERIALS_SUPPLY
25407: WHERE TRANSACTION_ID = l_great_grand_parent_txn_id
25408: AND SERIAL_NUM = L_SERIAL_NUMBER;
25409:
25410: IF (l_curr_status <> 7) THEN

Line 25613: FROM RCV_SERIALS_SUPPLY

25609: ELSE
25610: BEGIN
25611: SELECT '1'
25612: INTO L_DUMMY
25613: FROM RCV_SERIALS_SUPPLY
25614: WHERE TRANSACTION_ID = l_parent_transaction_id
25615: AND SERIAL_NUM = L_SERIAL_NUMBER;
25616:
25617: IF (l_curr_status <> 7) THEN

Line 26844: FROM RCV_SERIALS_SUPPLY

26840: ELSE --IF (serial_entered_on_parent(l_grand_parent_txn_id)) THEN
26841: BEGIN
26842: SELECT '1'
26843: INTO L_DUMMY
26844: FROM RCV_SERIALS_SUPPLY
26845: WHERE TRANSACTION_ID = l_grand_parent_txn_id
26846: AND SERIAL_NUM = L_SERIAL_NUMBER;
26847:
26848: IF (l_curr_status <> 7) THEN

Line 26969: FROM RCV_SERIALS_SUPPLY

26965: IF (serial_entered_on_parent(l_grand_parent_txn_id)) THEN
26966: BEGIN
26967: SELECT '1'
26968: INTO L_DUMMY
26969: FROM RCV_SERIALS_SUPPLY
26970: WHERE TRANSACTION_ID = l_grand_parent_txn_id
26971: AND SERIAL_NUM = L_SERIAL_NUMBER;
26972:
26973: IF (l_curr_status <> 7) THEN

Line 27208: FROM rcv_serials_supply rss

27204:
27205: BEGIN
27206: SELECT '1'
27207: INTO L_DUMMY
27208: FROM rcv_serials_supply rss
27209: , rcv_shipment_lines rsl
27210: WHERE rss.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
27211: AND rsl.shipment_header_id = l_shipment_header_id
27212: AND rsl.item_id = l_item_id

Line 27763: FROM RCV_SERIALS_SUPPLY

27759: ELSE --IF (serial_entered_on_parent(l_grand_parent_txn_id)) THEN
27760: BEGIN
27761: SELECT '1'
27762: INTO L_DUMMY
27763: FROM RCV_SERIALS_SUPPLY
27764: WHERE TRANSACTION_ID = l_grand_parent_txn_id
27765: AND SERIAL_NUM = L_SERIAL_NUMBER;
27766:
27767: IF (l_curr_status <> 7) THEN

Line 27885: FROM RCV_SERIALS_SUPPLY

27881: IF (serial_entered_on_parent(l_grand_parent_txn_id)) THEN
27882: BEGIN
27883: SELECT '1'
27884: INTO L_DUMMY
27885: FROM RCV_SERIALS_SUPPLY
27886: WHERE TRANSACTION_ID = l_grand_parent_txn_id
27887: AND SERIAL_NUM = L_SERIAL_NUMBER;
27888:
27889: IF (l_curr_status <> 7) THEN

Line 28118: FROM rcv_serials_supply rss

28114:
28115: BEGIN
28116: SELECT '1'
28117: INTO L_DUMMY
28118: FROM rcv_serials_supply rss
28119: , rcv_shipment_lines rsl
28120: WHERE rss.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
28121: AND rsl.shipment_header_id = l_shipment_header_id
28122: AND rsl.item_id = l_item_id