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_COMMON_APIS dependencies on RCV_SHIPMENT_LINES

Line 365: FROM po_requisition_headers prh, po_requisition_lines prl, rcv_shipment_lines rsl, mtl_system_items msi1, mtl_system_items msi2

361:
362: IF p_req_header_id IS NOT NULL THEN
363: SELECT 'N'
364: INTO l_lot_ser_flag
365: FROM po_requisition_headers prh, po_requisition_lines prl, rcv_shipment_lines rsl, mtl_system_items msi1, mtl_system_items msi2
366: WHERE prh.requisition_header_id = p_req_header_id
367: AND prl.requisition_header_id = prh.requisition_header_id
368: AND rsl.requisition_line_id = prl.requisition_line_id
369: AND rsl.item_id = msi1.inventory_item_id

Line 386: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh, mtl_system_items msi1, mtl_system_items msi2

382: AND ROWNUM = 1;
383: ELSIF p_shipment_header_id IS NOT NULL THEN
384: SELECT 'N'
385: INTO l_lot_ser_flag
386: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh, mtl_system_items msi1, mtl_system_items msi2
387: WHERE rsh.shipment_header_id = p_shipment_header_id
388: AND rsl.shipment_header_id = rsh.shipment_header_id
389: AND rsl.item_id = msi1.inventory_item_id
390: AND msi1.organization_id = rsl.from_organization_id

Line 2368: FROM rcv_shipment_lines rsl

2364: , rsl.po_line_id po_line_id
2365: , rsl.po_release_id po_release_id
2366: , rsl.item_id item_id
2367: , rsl.routing_header_id rsl_routing_id -- 14354069
2368: FROM rcv_shipment_lines rsl
2369: WHERE rsl.shipment_header_id = p_shipment_header_id
2370: AND rsl.po_header_id = NVL(p_po_header_id, rsl.po_header_id)
2371: AND(EXISTS(SELECT 1
2372: FROM wms_lpn_contents wlc

Line 2384: FROM rcv_shipment_lines rsl

2380: , rsl.po_line_id po_line_id
2381: , rsl.po_release_id po_release_id
2382: , rsl.item_id item_id
2383: , rsl.routing_header_id rsl_routing_id -- 14354069
2384: FROM rcv_shipment_lines rsl
2385: WHERE rsl.shipment_header_id = p_shipment_header_id
2386: AND rsl.po_header_id = NVL(p_po_header_id, rsl.po_header_id)
2387: AND (( ( rsl.asn_lpn_id IS NOT NULL
2388: AND rsl.asn_lpn_id in

Line 2545: * Routing ID is defined at shipment line level (rcv_shipment_lines)

2541:
2542: /*************************************************
2543: * Name: get_intshp_routing_id
2544: * This API returns routing id for a given shipment header ID
2545: * Routing ID is defined at shipment line level (rcv_shipment_lines)
2546: * We use the following rule to set headers routing ID
2547: * If there is one line detail needs inspection the entire shipment needs inspection
2548: * elsif there is one line detail needs direct receiving the entire shipmentneeds direct
2549: * else (all line detail are standard) the entire shipment is standard

Line 2573: FROM rcv_shipment_lines

2569: SELECT NVL(routing_header_id, 1)
2570: , po_header_id
2571: , po_line_id -- Bug 8242448
2572: , po_release_id -- Bug 8242448
2573: FROM rcv_shipment_lines
2574: WHERE shipment_header_id = p_shipment_header_id
2575: AND(
2576: (item_id IS NULL
2577: AND p_item_id IS NULL

Line 2635: , rcv_shipment_lines rsl

2631: BEGIN
2632: SELECT 'Y'
2633: INTO l_is_expense
2634: FROM po_requisition_lines prl
2635: , rcv_shipment_lines rsl
2636: WHERE prl.requisition_line_id = rsl.requisition_line_id
2637: AND prl.destination_type_code = 'EXPENSE'
2638: AND rsl.shipment_header_id = p_shipment_header_id
2639: AND rsl.item_id = NVL(p_item_id, rsl.item_id)

Line 3795: FROM rcv_shipment_lines rsl

3791: l_progress := '20';
3792: BEGIN
3793: SELECT COUNT (DISTINCT rsl.unit_of_measure)
3794: INTO l_count
3795: FROM rcv_shipment_lines rsl
3796: WHERE rsl.shipment_header_id = p_shipment_header_id
3797: AND rsl.unit_of_measure IS NOT NULL
3798: AND rsl.shipment_line_status_code <> 'FULLY RECEIVED'
3799: AND rsl.item_id = p_item_id

Line 3814: FROM rcv_shipment_lines rsl, mtl_units_of_measure mum

3810: l_progress := '30';
3811: BEGIN
3812: SELECT inv_ui_item_lovs.get_conversion_rate (mum.uom_code, p_organization_id, rsl.item_id)
3813: INTO x_uom_code
3814: FROM rcv_shipment_lines rsl, mtl_units_of_measure mum
3815: WHERE rsl.shipment_header_id = p_shipment_header_id
3816: AND rsl.unit_of_measure IS NOT NULL
3817: AND rsl.shipment_line_status_code <> 'FULLY RECEIVED'
3818: AND rsl.item_id = p_item_id

Line 3884: FROM rcv_shipment_lines rsl, mtl_units_of_measure mum

3880: l_progress := '20';
3881: BEGIN
3882: SELECT mum.uom_code, mum.uom_class
3883: INTO x_uom_code, l_class
3884: FROM rcv_shipment_lines rsl, mtl_units_of_measure mum
3885: WHERE rsl.shipment_header_id = p_shipment_header_id
3886: AND rsl.unit_of_measure IS NOT NULL
3887: AND rsl.shipment_line_status_code <> 'FULLY RECEIVED'
3888: AND rsl.item_description = p_item_desc

Line 3918: FROM rcv_shipment_lines rsl, mtl_units_of_measure mum

3914: l_progress := '30';
3915: BEGIN
3916: SELECT mum.uom_code, mum.uom_class
3917: INTO x_uom_code, l_class
3918: FROM rcv_shipment_lines rsl, mtl_units_of_measure mum
3919: WHERE rsl.shipment_header_id = p_shipment_header_id
3920: AND rsl.unit_of_measure IS NOT NULL
3921: AND rsl.shipment_line_status_code <> 'FULLY RECEIVED'
3922: AND rsl.item_id IS NULL

Line 4411: FROM rcv_shipment_lines rsl

4407:
4408: BEGIN
4409: SELECT COUNT(DISTINCT rsl.to_subinventory)
4410: INTO l_count
4411: FROM rcv_shipment_lines rsl
4412: WHERE rsl.shipment_header_id = p_shipment_header_id
4413: AND rsl.item_id = NVL(p_item_id, rsl.item_id)
4414: AND rsl.to_subinventory IS NOT NULL;
4415: EXCEPTION

Line 4430: FROM rcv_shipment_lines rsl

4426: SELECT rsl.to_subinventory
4427: , NVL(rsl.locator_id, -1)
4428: INTO x_sub_code
4429: , l_locator_id
4430: FROM rcv_shipment_lines rsl
4431: WHERE rsl.shipment_header_id = p_shipment_header_id
4432: AND rsl.item_id = NVL(p_item_id, rsl.item_id)
4433: AND rsl.to_subinventory IS NOT NULL
4434: AND ROWNUM = 1;

Line 4738: FROM hr_locations hl, rcv_shipment_lines rsl

4734: END IF;
4735: ELSIF p_shipment_header_id IS NOT NULL THEN
4736: SELECT distinct( hl.location_code )
4737: into x_location_code
4738: FROM hr_locations hl, rcv_shipment_lines rsl
4739: WHERE hl.location_id = nvl(rsl.deliver_to_location_id,rsl.ship_to_location_id)--bug10349270 for ASN receipt,we should get the default location against RSL.ship_to_location
4740: AND rsl.shipment_header_id = p_shipment_header_id
4741: AND rsl.item_id = NVL(p_item_id, rsl.item_id)
4742: AND rsl.to_organization_id = p_organization_id

Line 4891: FROM rcv_shipment_lines

4887: SELECT 'Y'
4888: INTO l_rcvreq_use_intship
4889: FROM dual
4890: WHERE EXISTS ( SELECT 1
4891: FROM rcv_shipment_lines
4892: WHERE shipment_header_id = l_shipment_header_id
4893: AND requisition_line_id IS NOT NULL
4894: AND source_document_code = 'REQ'
4895: );

Line 4910: FROM rcv_shipment_lines rsl

4906: END IF;
4907:
4908: SELECT DISTINCT(rsl.item_revision)
4909: INTO x_revision_code
4910: FROM rcv_shipment_lines rsl
4911: WHERE rsl.shipment_header_id = l_shipment_header_id
4912: AND rsl.to_organization_id = p_organization_id
4913: AND rsl.item_id = NVL(p_item_id,rsl.item_id)
4914: AND rsl.source_document_code = DECODE (p_document_type, 'INTSHIP', l_doc_type, 'REQ' ,'REQ', 'ASN','PO', 'REQ' )

Line 6271: FROM rcv_shipment_lines rsl

6267: SELECT DISTINCT rsl.shipment_header_id
6268: , rsl.from_organization_id
6269: INTO x_shipment_header_id
6270: , x_from_org_id
6271: FROM rcv_shipment_lines rsl
6272: WHERE item_id = p_item_id
6273: AND to_organization_id = p_organization_id
6274: AND EXISTS(
6275: SELECT 1

Line 6334: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc,wms_license_plate_numbers wln

6330: SELECT DISTINCT rsl.shipment_header_id
6331: , rsl.from_organization_id
6332: INTO x_shipment_header_id
6333: , x_from_org_id
6334: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc,wms_license_plate_numbers wln
6335: WHERE rsl.item_id = wlc.inventory_item_id
6336: AND to_organization_id = p_organization_id
6337: AND wln.lpn_id IN ( SELECT lpn_id
6338: FROM wms_license_plate_numbers

Line 6359: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc

6355: SELECT DISTINCT rsl.shipment_header_id
6356: , rsl.from_organization_id
6357: INTO x_shipment_header_id
6358: , x_from_org_id
6359: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc
6360: WHERE rsl.item_id = wlc.inventory_item_id
6361: AND to_organization_id = p_organization_id
6362: AND wlc.parent_lpn_id IN ( SELECT lpn_id
6363: FROM wms_license_plate_numbers

Line 6404: FROM rcv_shipment_lines rsl

6400: SELECT DISTINCT rsl.shipment_header_id
6401: , rsl.from_organization_id
6402: INTO x_shipment_header_id
6403: , x_from_org_id
6404: FROM rcv_shipment_lines rsl
6405: WHERE item_id = p_item_id
6406: AND to_organization_id = p_organization_id
6407: AND EXISTS(
6408: SELECT 1

Line 6434: FROM rcv_shipment_lines rsl

6430: SELECT DISTINCT rsl.shipment_header_id
6431: , rsl.from_organization_id
6432: INTO x_shipment_header_id
6433: , x_from_org_id
6434: FROM rcv_shipment_lines rsl
6435: WHERE item_id = p_item_id
6436: AND to_organization_id = p_organization_id
6437: AND EXISTS(
6438: SELECT 1

Line 6733: FROM po_distributions_all pod, rcv_shipment_lines rsl

6729:
6730: ELSIF p_document_type = 'ASN' THEN
6731: SELECT COUNT(COUNT(*))
6732: INTO l_project_tasks_count
6733: FROM po_distributions_all pod, rcv_shipment_lines rsl
6734: WHERE pod.po_header_id = rsl.po_header_id
6735: AND rsl.shipment_header_id = p_shipment_header_id
6736: AND (p_item_id IS NULL OR rsl.item_id = p_item_id)
6737: AND ( (p_item_rev IS NULL OR rsl.item_revision IS NULL) OR

Line 6746: FROM po_distributions_all pod, rcv_shipment_lines rsl

6742: GROUP BY project_id, task_id;
6743:
6744: SELECT COUNT(COUNT(*))
6745: INTO l_distributions_count
6746: FROM po_distributions_all pod, rcv_shipment_lines rsl
6747: WHERE pod.po_header_id = rsl.po_header_id
6748: AND rsl.po_line_id = pod.po_line_id(+)
6749: AND rsl.po_line_location_id = pod.line_location_id(+)
6750: AND rsl.shipment_header_id = p_shipment_header_id

Line 6953: FROM rcv_shipment_lines rsl

6949: Id, Requisition #, To Organization Id and Item ID
6950: */
6951: SELECT DISTINCT rsl.from_organization_id
6952: INTO l_from_org_id
6953: FROM rcv_shipment_lines rsl
6954: WHERE item_id = p_item_id
6955: AND to_organization_id = p_to_org_id
6956: AND shipment_header_id = p_ship_head_id
6957: AND EXISTS(

Line 7184: FROM rcv_shipment_lines rsl

7180: Id, Requisition #, To Organization Id and Item ID
7181: */
7182: SELECT DISTINCT rsl.from_organization_id
7183: INTO l_from_org_id
7184: FROM rcv_shipment_lines rsl
7185: WHERE item_id = p_item_id
7186: AND to_organization_id = p_to_org_id
7187: AND shipment_header_id = p_ship_head_id
7188: AND EXISTS(

Line 7286: FROM po_distributions_all pod, rcv_shipment_lines rsl

7282: ELSIF p_document_type = 'ASN' THEN
7283: BEGIN
7284: SELECT pod.task_id
7285: INTO l_task_id
7286: FROM po_distributions_all pod, rcv_shipment_lines rsl
7287: WHERE pod.po_header_id = rsl.po_header_id
7288: AND rsl.po_line_id = pod.po_line_id(+)
7289: AND rsl.po_line_location_id = pod.line_location_id(+)
7290: AND rsl.shipment_header_id = p_shipment_header_id

Line 7951: FROM rcv_shipment_lines rsl

7947: START WITH wlpn2.lpn_id = wlpn1.lpn_id
7948: CONNECT BY PRIOR wlpn2.lpn_id = wlpn2.parent_lpn_id
7949: INTERSECT
7950: SELECT rsl.asn_lpn_id
7951: FROM rcv_shipment_lines rsl
7952: WHERE rsl.shipment_header_id = rsh.shipment_header_id
7953: AND NOT exists (SELECT 1
7954: FROM rcv_transactions_interface rti
7955: WHERE rti.lpn_id = rsl.asn_lpn_id

Line 8116: FROM rcv_shipment_lines rsl, po_requisition_lines prl

8112: END IF;
8113: BEGIN
8114: SELECT count(DISTINCT rsl.shipment_header_id)
8115: INTO x_open_shipments
8116: FROM rcv_shipment_lines rsl, po_requisition_lines prl
8117: WHERE to_organization_id = p_organization_id
8118: AND nvl(rsl.shipment_line_status_code, ' ') <> 'FULLY RECEIVED'
8119: AND prl.requisition_header_id = p_requisition_header_id
8120: AND rsl.requisition_line_id = prl.requisition_line_id;

Line 8172: FROM rcv_transactions rt , rcv_shipment_lines rsl, mtl_units_of_measure mum

8168: l_progress := '20';
8169: BEGIN
8170: SELECT DISTINCT mum.uom_code
8171: INTO l_uom_code
8172: FROM rcv_transactions rt , rcv_shipment_lines rsl, mtl_units_of_measure mum
8173: WHERE rt.transaction_type = 'RECEIVE'
8174: AND rsl.item_id = p_item_id
8175: AND rt.organization_id = p_organization_id
8176: AND rsl.shipment_header_id = rt.shipment_header_id