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 454: FROM mtl_system_items msi, rcv_shipment_lines rsl

450: , msi.revision_qty_control_code
451: INTO x_lot_control_code
452: , x_serial_control_code
453: , x_revision_control_code
454: FROM mtl_system_items msi, rcv_shipment_lines rsl
455: WHERE rsl.shipment_line_id = p_shipment_line_id
456: AND rsl.to_organization_id = p_org_id
457: AND msi.inventory_item_id = rsl.item_id
458: AND msi.organization_id = rsl.from_organization_id;

Line 1179: rcv_shipment_lines rsl

1175: -- ,l_lpn_context
1176: ,l_po_line_location_id
1177: ,l_po_header_id
1178: FROM
1179: rcv_shipment_lines rsl
1180: ,mtl_system_items msi
1181: WHERE
1182: rsl.shipment_line_id = p_shipment_line_id
1183: AND rsl.shipment_header_id = p_shipment_header_id

Line 3709: from rcv_shipment_lines rsl

3705: l_progress := 'WMSINB-40410';
3706:
3707: select nvl(asn_line_flag,'N')
3708: into l_asn_line_flag
3709: from rcv_shipment_lines rsl
3710: where rsl.shipment_line_id = p_old_reference_id
3711: ;
3712:
3713: If l_asn_line_flag = 'Y' then

Line 3717: FROM rcv_shipment_lines rsl, po_line_locations_all poll

3713: If l_asn_line_flag = 'Y' then
3714: -- CASE FOR ASN
3715: SELECT 1
3716: INTO l_same_doc
3717: FROM rcv_shipment_lines rsl, po_line_locations_all poll
3718: WHERE rsl.shipment_line_id = p_old_reference_id
3719: AND poll.line_location_id = rsl.po_line_location_id
3720: AND poll.po_header_id in ( select poll1.po_header_id
3721: from rcv_shipment_lines rsl1, po_line_locations_all poll1

Line 3721: from rcv_shipment_lines rsl1, po_line_locations_all poll1

3717: FROM rcv_shipment_lines rsl, po_line_locations_all poll
3718: WHERE rsl.shipment_line_id = p_old_reference_id
3719: AND poll.line_location_id = rsl.po_line_location_id
3720: AND poll.po_header_id in ( select poll1.po_header_id
3721: from rcv_shipment_lines rsl1, po_line_locations_all poll1
3722: where rsl1.shipment_line_id = p_new_reference_id
3723: and poll1.line_location_id = rsl1.po_line_location_id )
3724: AND rownum < 2;
3725: l_progress := 'WMSINB-40411';

Line 3731: FROM rcv_shipment_lines rsl

3727: -- CASE FOR INTSHIP/INTREQ
3728: l_progress := 'WMSINB-40412';
3729: SELECT 1
3730: INTO l_same_doc
3731: FROM rcv_shipment_lines rsl
3732: WHERE rsl.shipment_line_id = p_old_reference_id
3733: AND rsl.shipment_header_id in ( select rsl1.shipment_header_id
3734: from rcv_shipment_lines rsl1
3735: where rsl1.shipment_line_id = p_new_reference_id

Line 3734: from rcv_shipment_lines rsl1

3730: INTO l_same_doc
3731: FROM rcv_shipment_lines rsl
3732: WHERE rsl.shipment_line_id = p_old_reference_id
3733: AND rsl.shipment_header_id in ( select rsl1.shipment_header_id
3734: from rcv_shipment_lines rsl1
3735: where rsl1.shipment_line_id = p_new_reference_id
3736: )
3737: AND rownum < 2;
3738: l_progress := 'WMSINB-40413';

Line 4330: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

4326: BEGIN
4327: SELECT rsl.po_line_location_id,rsl.po_distribution_id,
4328: Decode(rsh.asn_type,'ASN','Y','N'),Decode(rsh.receipt_source_code,'INTERNAL ORDER','Y','N')
4329: INTO l_po_line_location_id,l_po_distribution_id,l_is_asn,l_is_req
4330: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
4331: WHERE rsl.shipment_line_id = p_shipment_line_id
4332: AND rsl.shipment_header_id = rsh.shipment_header_id;
4333: EXCEPTION
4334: WHEN OTHERS THEN

Line 7952: -- FROM rcv_shipment_lines

7948: BEGIN
7949: -- This part of code is changed to take into account ASN_TYPE
7950: --SELECT Nvl(asn_line_flag, 'N')
7951: -- INTO l_asn_line_flag
7952: -- FROM rcv_shipment_lines
7953: -- WHERE shipment_line_id = l_rti_rec.shipment_line_id;
7954: --
7955: select decode(ASN_TYPE,'ASN','Y','N')
7956: into l_asn_line_flag

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

10543: , rcv_shipment_headers rsh
10544: WHERE rt.transaction_id = p_txn_source_id
10545: AND rt.shipment_header_id = rsh.shipment_header_id
10546: AND rt.organization_id = p_to_org_id
10547: AND exists (SELECT '1' FROM rcv_shipment_lines rsl
10548: WHERE rsl.shipment_header_id = rsh.shipment_header_id
10549: AND rt.organization_id = rsl.to_organization_id);
10550: EXCEPTION
10551: WHEN no_data_found THEN

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

10575: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn
10576: WHERE RSH.SHIPMENT_HEADER_ID = WLPN.SOURCE_HEADER_ID
10577: AND WLPN.SOURCE_HEADER_ID IS NOT NULL
10578: AND wlpn.lpn_id = p_lpn_id
10579: AND exists (SELECT '1' FROM rcv_shipment_lines rsl
10580: WHERE rsl.shipment_header_id = rsh.shipment_header_id
10581: AND wlpn.organization_id = rsl.to_organization_id);
10582: EXCEPTION
10583: WHEN NO_DATA_FOUND THEN

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

10590: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn
10591: WHERE RSH.SHIPMENT_NUM = WLPN.SOURCE_NAME
10592: AND WLPN.SOURCE_NAME IS NOT NULL
10593: AND wlpn.lpn_id = p_lpn_id
10594: AND exists (SELECT '1' FROM rcv_shipment_lines rsl
10595: WHERE rsl.shipment_header_id = rsh.shipment_header_id
10596: AND wlpn.organization_id = rsl.to_organization_id);
10597:
10598: --Two exception blocks as such necessary?

Line 17247: , rcv_shipment_lines rsl

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

Line 18217: -- FROM rcv_shipment_lines

18213: IF l_shipment_line_id IS NOT NULL THEN
18214: -- THIS IS CHANGED TO TAKE INTO ACCOUNT ASN_TYPE
18215: --SELECT Nvl(asn_line_flag, 'N')
18216: -- INTO l_asn_line_flag
18217: -- FROM rcv_shipment_lines
18218: -- WHERE shipment_line_id = l_shipment_line_id;
18219: select decode(ASN_TYPE,'ASN','Y','N')
18220: into l_asn_line_flag
18221: from rcv_shipment_headers

Line 18647: , rcv_shipment_lines rsl

18643: */
18644: SELECT nvl(SUM(rls.primary_quantity),0)--Bug:5489462
18645: INTO L_RLS_PRIMARY_QUANTITY
18646: FROM rcv_lots_supply rls
18647: , rcv_shipment_lines rsl
18648: WHERE rsl.SHIPMENT_LINE_ID = rls.SHIPMENT_LINE_ID
18649: AND rsl.shipment_header_id = l_shipment_header_id
18650: AND rsl.item_id = l_item_id
18651: AND rls.SUPPLY_TYPE_CODE = 'SHIPMENT'

Line 18944: , rcv_shipment_lines rsl

18940: BEGIN
18941: SELECT nvl(SUM(rls.primary_quantity),0) --Bug:5489462
18942: INTO L_RLS_PRIMARY_QUANTITY
18943: FROM rcv_lots_supply rls
18944: , rcv_shipment_lines rsl
18945: WHERE rls.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
18946: AND rsl.shipment_header_id = l_shipment_header_id
18947: AND rsl.item_id = l_item_id
18948: AND rls.SUPPLY_TYPE_CODE = 'SHIPMENT'

Line 19458: , rcv_shipment_lines rsl

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

Line 19588: , rcv_shipment_lines rsl

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

Line 19623: FROM rcv_shipment_lines

19619: */
19620: IF L_CURR_ORG_ID <> l_org_id THEN
19621: BEGIN
19622: SELECT from_organization_id INTO l_from_org_id
19623: FROM rcv_shipment_lines
19624: WHERE shipment_line_id = L_SHIPMENT_LINE_ID;
19625: EXCEPTION
19626: WHEN NO_DATA_FOUND THEN
19627: -- RAISE AN ERROR

Line 20512: , rcv_shipment_lines rsl

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

Line 20648: , rcv_shipment_lines rsl

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

Line 20684: FROM rcv_shipment_lines

20680: */
20681: BEGIN
20682: SELECT from_organization_id
20683: INTO l_from_org_id
20684: FROM rcv_shipment_lines
20685: WHERE shipment_line_id = L_SHIPMENT_LINE_ID;
20686: EXCEPTION
20687: WHEN NO_DATA_FOUND THEN
20688: -- RAISE AN ERROR

Line 26267: , rcv_shipment_lines rsl

26263: BEGIN
26264: SELECT nvl(SUM(rls.primary_quantity),0) --Bug:5489462
26265: INTO L_RLS_PRIMARY_QUANTITY
26266: FROM rcv_lots_supply rls
26267: , rcv_shipment_lines rsl
26268: WHERE rsl.SHIPMENT_LINE_ID = rls.SHIPMENT_LINE_ID
26269: AND rsl.shipment_header_id = l_shipment_header_id
26270: AND rsl.item_id = l_item_id
26271: AND rls.SUPPLY_TYPE_CODE = 'SHIPMENT'

Line 27209: , rcv_shipment_lines rsl

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

Line 28119: , rcv_shipment_lines rsl

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