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_SHIPMENT_LINES

Line 478: FROM mtl_system_items msi, rcv_shipment_lines rsl

474: , msi.revision_qty_control_code
475: INTO x_lot_control_code
476: , x_serial_control_code
477: , x_revision_control_code
478: FROM mtl_system_items msi, rcv_shipment_lines rsl
479: WHERE rsl.shipment_line_id = p_shipment_line_id
480: AND rsl.to_organization_id = p_org_id
481: AND msi.inventory_item_id = rsl.item_id
482: AND msi.organization_id = rsl.from_organization_id;

Line 1203: rcv_shipment_lines rsl

1199: -- ,l_lpn_context
1200: ,l_po_line_location_id
1201: ,l_po_header_id
1202: FROM
1203: rcv_shipment_lines rsl
1204: ,mtl_system_items msi
1205: WHERE
1206: rsl.shipment_line_id = p_shipment_line_id
1207: AND rsl.shipment_header_id = p_shipment_header_id

Line 3764: from rcv_shipment_lines rsl

3760: l_progress := 'WMSINB-40410';
3761:
3762: select nvl(asn_line_flag,'N')
3763: into l_asn_line_flag
3764: from rcv_shipment_lines rsl
3765: where rsl.shipment_line_id = p_old_reference_id
3766: ;
3767:
3768: If l_asn_line_flag = 'Y' then

Line 3772: FROM rcv_shipment_lines rsl, po_line_locations_all poll

3768: If l_asn_line_flag = 'Y' then
3769: -- CASE FOR ASN
3770: SELECT 1
3771: INTO l_same_doc
3772: FROM rcv_shipment_lines rsl, po_line_locations_all poll
3773: WHERE rsl.shipment_line_id = p_old_reference_id
3774: AND poll.line_location_id = rsl.po_line_location_id
3775: AND poll.po_header_id in ( select poll1.po_header_id
3776: from rcv_shipment_lines rsl1, po_line_locations_all poll1

Line 3776: from rcv_shipment_lines rsl1, po_line_locations_all poll1

3772: FROM rcv_shipment_lines rsl, po_line_locations_all poll
3773: WHERE rsl.shipment_line_id = p_old_reference_id
3774: AND poll.line_location_id = rsl.po_line_location_id
3775: AND poll.po_header_id in ( select poll1.po_header_id
3776: from rcv_shipment_lines rsl1, po_line_locations_all poll1
3777: where rsl1.shipment_line_id = p_new_reference_id
3778: and poll1.line_location_id = rsl1.po_line_location_id )
3779: AND rownum < 2;
3780: l_progress := 'WMSINB-40411';

Line 3786: FROM rcv_shipment_lines rsl

3782: -- CASE FOR INTSHIP/INTREQ
3783: l_progress := 'WMSINB-40412';
3784: SELECT 1
3785: INTO l_same_doc
3786: FROM rcv_shipment_lines rsl
3787: WHERE rsl.shipment_line_id = p_old_reference_id
3788: AND rsl.shipment_header_id in ( select rsl1.shipment_header_id
3789: from rcv_shipment_lines rsl1
3790: where rsl1.shipment_line_id = p_new_reference_id

Line 3789: from rcv_shipment_lines rsl1

3785: INTO l_same_doc
3786: FROM rcv_shipment_lines rsl
3787: WHERE rsl.shipment_line_id = p_old_reference_id
3788: AND rsl.shipment_header_id in ( select rsl1.shipment_header_id
3789: from rcv_shipment_lines rsl1
3790: where rsl1.shipment_line_id = p_new_reference_id
3791: )
3792: AND rownum < 2;
3793: l_progress := 'WMSINB-40413';

Line 4403: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

4399: BEGIN
4400: SELECT rsl.po_line_location_id,rsl.po_distribution_id,
4401: Decode(rsh.asn_type,'ASN','Y', 'ASBN','Y','N'),Decode(rsh.receipt_source_code,'INTERNAL ORDER','Y','N')
4402: INTO l_po_line_location_id,l_po_distribution_id,l_is_asn,l_is_req
4403: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
4404: WHERE rsl.shipment_line_id = p_shipment_line_id
4405: AND rsl.shipment_header_id = rsh.shipment_header_id;
4406: EXCEPTION
4407: WHEN OTHERS THEN

Line 8262: -- FROM rcv_shipment_lines

8258: BEGIN
8259: -- This part of code is changed to take into account ASN_TYPE
8260: --SELECT Nvl(asn_line_flag, 'N')
8261: -- INTO l_asn_line_flag
8262: -- FROM rcv_shipment_lines
8263: -- WHERE shipment_line_id = l_rti_rec.shipment_line_id;
8264: --
8265: --Bug 13891514 Adding ASBN as well because the validations/processing is same for ASN/ASBN
8266: select decode(ASN_TYPE,'ASN','Y', 'ASBN','Y','N')

Line 11024: AND exists (SELECT '1' FROM rcv_shipment_lines rsl

11020: , rcv_shipment_headers rsh
11021: WHERE rt.transaction_id = p_txn_source_id
11022: AND rt.shipment_header_id = rsh.shipment_header_id
11023: AND rt.organization_id = p_to_org_id
11024: AND exists (SELECT '1' FROM rcv_shipment_lines rsl
11025: WHERE rsl.shipment_header_id = rsh.shipment_header_id
11026: AND rt.organization_id = rsl.to_organization_id);
11027: EXCEPTION
11028: WHEN no_data_found THEN

Line 11056: AND exists (SELECT '1' FROM rcv_shipment_lines rsl

11052: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn
11053: WHERE RSH.SHIPMENT_HEADER_ID = WLPN.SOURCE_HEADER_ID
11054: AND WLPN.SOURCE_HEADER_ID IS NOT NULL
11055: AND wlpn.lpn_id = p_lpn_id
11056: AND exists (SELECT '1' FROM rcv_shipment_lines rsl
11057: WHERE rsl.shipment_header_id = rsh.shipment_header_id
11058: AND wlpn.organization_id = rsl.to_organization_id);
11059: EXCEPTION
11060: WHEN NO_DATA_FOUND THEN

Line 11071: AND exists (SELECT '1' FROM rcv_shipment_lines rsl

11067: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn
11068: WHERE RSH.SHIPMENT_NUM = WLPN.SOURCE_NAME
11069: AND WLPN.SOURCE_NAME IS NOT NULL
11070: AND wlpn.lpn_id = p_lpn_id
11071: AND exists (SELECT '1' FROM rcv_shipment_lines rsl
11072: WHERE rsl.shipment_header_id = rsh.shipment_header_id
11073: AND wlpn.organization_id = rsl.to_organization_id);
11074:
11075: --Two exception blocks as such necessary?

Line 18161: , rcv_shipment_lines rsl

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
18165: AND rss.supply_type_code = 'SHIPMENT'

Line 19233: -- FROM rcv_shipment_lines

19229: IF l_shipment_line_id IS NOT NULL THEN
19230: -- THIS IS CHANGED TO TAKE INTO ACCOUNT ASN_TYPE
19231: --SELECT Nvl(asn_line_flag, 'N')
19232: -- INTO l_asn_line_flag
19233: -- FROM rcv_shipment_lines
19234: -- WHERE shipment_line_id = l_shipment_line_id;
19235: --Bug 13891514 Adding ASBN as well because the validations/processing is same for ASN/ASBN
19236: select decode(ASN_TYPE,'ASN','Y', 'ASBN','Y','N')
19237: into l_asn_line_flag

Line 19722: , rcv_shipment_lines rsl

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
19726: --AND rls.SHIPMENT_LINE_ID = L_SHIPMENT_LINE_ID --9466813

Line 20079: , rcv_shipment_lines rsl

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
20083: AND rls.SUPPLY_TYPE_CODE = 'SHIPMENT'

Line 20617: , rcv_shipment_lines rsl

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
20621: AND rss.supply_type_code = 'SHIPMENT'

Line 20747: , rcv_shipment_lines rsl

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
20751: AND rss.SUPPLY_TYPE_CODE = 'SHIPMENT'

Line 20782: FROM rcv_shipment_lines

20778: */
20779: IF L_CURR_ORG_ID <> l_org_id THEN
20780: BEGIN
20781: SELECT from_organization_id INTO l_from_org_id
20782: FROM rcv_shipment_lines
20783: WHERE shipment_line_id = L_SHIPMENT_LINE_ID;
20784: EXCEPTION
20785: WHEN NO_DATA_FOUND THEN
20786: -- RAISE AN ERROR

Line 21707: , rcv_shipment_lines rsl

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
21711: AND rss.supply_type_code = 'SHIPMENT'

Line 21843: , rcv_shipment_lines rsl

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
21847: AND rss.SUPPLY_TYPE_CODE = 'SHIPMENT'

Line 21879: FROM rcv_shipment_lines

21875: */
21876: BEGIN
21877: SELECT from_organization_id
21878: INTO l_from_org_id
21879: FROM rcv_shipment_lines
21880: WHERE shipment_line_id = L_SHIPMENT_LINE_ID;
21881: EXCEPTION
21882: WHEN NO_DATA_FOUND THEN
21883: -- RAISE AN ERROR

Line 27076: , rcv_shipment_lines rsl

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
27080: AND rls.SUPPLY_TYPE_CODE = 'SHIPMENT'

Line 27862: , rcv_shipment_lines rsl

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
27866: AND rss.SUPPLY_TYPE_CODE = 'SHIPMENT'

Line 28790: , rcv_shipment_lines rsl

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
28794: AND rss.SUPPLY_TYPE_CODE = 'SHIPMENT'

Line 29413: FROM rcv_shipment_lines rsl

29409: CURSOR c_rsl_cursor IS
29410: SELECT Sum(rsl.quantity_shipped) quantity_shipped ,
29411: Sum(rsl.quantity_received) quantity_received,
29412: rsl.unit_of_measure
29413: FROM rcv_shipment_lines rsl
29414: WHERE rsl.asn_lpn_id = p_lpn_id
29415: AND rsl.to_organization_id = p_organization_id
29416: AND rsl.item_id = p_item_id
29417: GROUP BY rsl.item_id , rsl.to_organization_id, rsl.asn_lpn_id, rsl.unit_of_measure;