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 2251: FROM rcv_shipment_lines rsl

2247: SELECT NVL(p_po_header_id, rsl.po_header_id) po_header_id
2248: , rsl.po_line_id po_line_id
2249: , rsl.po_release_id po_release_id
2250: , rsl.item_id item_id
2251: FROM rcv_shipment_lines rsl
2252: WHERE rsl.shipment_header_id = p_shipment_header_id
2253: AND rsl.po_header_id = NVL(p_po_header_id, rsl.po_header_id)
2254: AND(EXISTS(SELECT 1
2255: FROM wms_lpn_contents wlc

Line 2266: FROM rcv_shipment_lines rsl

2262: SELECT NVL(p_po_header_id, rsl.po_header_id) po_header_id
2263: , rsl.po_line_id po_line_id
2264: , rsl.po_release_id po_release_id
2265: , rsl.item_id item_id
2266: FROM rcv_shipment_lines rsl
2267: WHERE rsl.shipment_header_id = p_shipment_header_id
2268: AND rsl.po_header_id = NVL(p_po_header_id, rsl.po_header_id)
2269: AND (( ( rsl.asn_lpn_id IS NOT NULL
2270: AND rsl.asn_lpn_id in

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

2406:
2407: /*************************************************
2408: * Name: get_intshp_routing_id
2409: * This API returns routing id for a given shipment header ID
2410: * Routing ID is defined at shipment line level (rcv_shipment_lines)
2411: * We use the following rule to set headers routing ID
2412: * If there is one line detail needs inspection the entire shipment needs inspection
2413: * elsif there is one line detail needs direct receiving the entire shipmentneeds direct
2414: * else (all line detail are standard) the entire shipment is standard

Line 2432: FROM rcv_shipment_lines

2428:
2429: CURSOR intshp_rsl_routing_cur IS
2430: SELECT NVL(routing_header_id, 1)
2431: , po_header_id
2432: FROM rcv_shipment_lines
2433: WHERE shipment_header_id = p_shipment_header_id
2434: AND(
2435: (item_id IS NULL
2436: AND p_item_id IS NULL

Line 2493: , rcv_shipment_lines rsl

2489: BEGIN
2490: SELECT 'Y'
2491: INTO l_is_expense
2492: FROM po_requisition_lines prl
2493: , rcv_shipment_lines rsl
2494: WHERE prl.requisition_line_id = rsl.requisition_line_id
2495: AND prl.destination_type_code = 'EXPENSE'
2496: AND rsl.shipment_header_id = p_shipment_header_id
2497: AND rsl.item_id = NVL(p_item_id, rsl.item_id)

Line 3928: FROM rcv_shipment_lines rsl

3924:
3925: BEGIN
3926: SELECT COUNT(DISTINCT rsl.to_subinventory)
3927: INTO l_count
3928: FROM rcv_shipment_lines rsl
3929: WHERE rsl.shipment_header_id = p_shipment_header_id
3930: AND rsl.item_id = NVL(p_item_id, rsl.item_id)
3931: AND rsl.to_subinventory IS NOT NULL;
3932: EXCEPTION

Line 3947: FROM rcv_shipment_lines rsl

3943: SELECT rsl.to_subinventory
3944: , NVL(rsl.locator_id, -1)
3945: INTO x_sub_code
3946: , l_locator_id
3947: FROM rcv_shipment_lines rsl
3948: WHERE rsl.shipment_header_id = p_shipment_header_id
3949: AND rsl.item_id = NVL(p_item_id, rsl.item_id)
3950: AND rsl.to_subinventory IS NOT NULL
3951: AND ROWNUM = 1;

Line 4215: FROM hr_locations hl, rcv_shipment_lines rsl

4211: END IF;
4212: ELSIF p_shipment_header_id IS NOT NULL THEN
4213: SELECT distinct( hl.location_code )
4214: into x_location_code
4215: FROM hr_locations hl, rcv_shipment_lines rsl
4216: WHERE hl.location_id = rsl.deliver_to_location_id
4217: AND rsl.shipment_header_id = p_shipment_header_id
4218: AND rsl.item_id = NVL(p_item_id, rsl.item_id)
4219: AND rsl.to_organization_id = p_organization_id

Line 4368: FROM rcv_shipment_lines

4364: SELECT 'Y'
4365: INTO l_rcvreq_use_intship
4366: FROM dual
4367: WHERE EXISTS ( SELECT 1
4368: FROM rcv_shipment_lines
4369: WHERE shipment_header_id = l_shipment_header_id
4370: AND requisition_line_id IS NOT NULL
4371: AND source_document_code = 'REQ'
4372: );

Line 4387: FROM rcv_shipment_lines rsl

4383: END IF;
4384:
4385: SELECT DISTINCT(rsl.item_revision)
4386: INTO x_revision_code
4387: FROM rcv_shipment_lines rsl
4388: WHERE rsl.shipment_header_id = l_shipment_header_id
4389: AND rsl.to_organization_id = p_organization_id
4390: AND rsl.item_id = NVL(p_item_id,rsl.item_id)
4391: AND rsl.source_document_code = DECODE (p_document_type, 'INTSHIP', l_doc_type, 'REQ' ,'REQ', 'ASN','PO', 'REQ' )

Line 5739: FROM rcv_shipment_lines rsl

5735: SELECT DISTINCT rsl.shipment_header_id
5736: , rsl.from_organization_id
5737: INTO x_shipment_header_id
5738: , x_from_org_id
5739: FROM rcv_shipment_lines rsl
5740: WHERE item_id = p_item_id
5741: AND to_organization_id = p_organization_id
5742: AND EXISTS(
5743: SELECT 1

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

5798: SELECT DISTINCT rsl.shipment_header_id
5799: , rsl.from_organization_id
5800: INTO x_shipment_header_id
5801: , x_from_org_id
5802: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc,wms_license_plate_numbers wln
5803: WHERE rsl.item_id = wlc.inventory_item_id
5804: AND to_organization_id = p_organization_id
5805: AND wln.lpn_id IN ( SELECT lpn_id
5806: FROM wms_license_plate_numbers

Line 5827: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc

5823: SELECT DISTINCT rsl.shipment_header_id
5824: , rsl.from_organization_id
5825: INTO x_shipment_header_id
5826: , x_from_org_id
5827: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc
5828: WHERE rsl.item_id = wlc.inventory_item_id
5829: AND to_organization_id = p_organization_id
5830: AND wlc.parent_lpn_id IN ( SELECT lpn_id
5831: FROM wms_license_plate_numbers

Line 5872: FROM rcv_shipment_lines rsl

5868: SELECT DISTINCT rsl.shipment_header_id
5869: , rsl.from_organization_id
5870: INTO x_shipment_header_id
5871: , x_from_org_id
5872: FROM rcv_shipment_lines rsl
5873: WHERE item_id = p_item_id
5874: AND to_organization_id = p_organization_id
5875: AND EXISTS(
5876: SELECT 1

Line 5902: FROM rcv_shipment_lines rsl

5898: SELECT DISTINCT rsl.shipment_header_id
5899: , rsl.from_organization_id
5900: INTO x_shipment_header_id
5901: , x_from_org_id
5902: FROM rcv_shipment_lines rsl
5903: WHERE item_id = p_item_id
5904: AND to_organization_id = p_organization_id
5905: AND EXISTS(
5906: SELECT 1

Line 6201: FROM po_distributions_all pod, rcv_shipment_lines rsl

6197:
6198: ELSIF p_document_type = 'ASN' THEN
6199: SELECT COUNT(COUNT(*))
6200: INTO l_project_tasks_count
6201: FROM po_distributions_all pod, rcv_shipment_lines rsl
6202: WHERE pod.po_header_id = rsl.po_header_id
6203: AND rsl.shipment_header_id = p_shipment_header_id
6204: AND (p_item_id IS NULL OR rsl.item_id = p_item_id)
6205: AND ( (p_item_rev IS NULL OR rsl.item_revision IS NULL) OR

Line 6214: FROM po_distributions_all pod, rcv_shipment_lines rsl

6210: GROUP BY project_id, task_id;
6211:
6212: SELECT COUNT(COUNT(*))
6213: INTO l_distributions_count
6214: FROM po_distributions_all pod, rcv_shipment_lines rsl
6215: WHERE pod.po_header_id = rsl.po_header_id
6216: AND rsl.po_line_id = pod.po_line_id(+)
6217: AND rsl.po_line_location_id = pod.line_location_id(+)
6218: AND rsl.shipment_header_id = p_shipment_header_id

Line 6421: FROM rcv_shipment_lines rsl

6417: Id, Requisition #, To Organization Id and Item ID
6418: */
6419: SELECT DISTINCT rsl.from_organization_id
6420: INTO l_from_org_id
6421: FROM rcv_shipment_lines rsl
6422: WHERE item_id = p_item_id
6423: AND to_organization_id = p_to_org_id
6424: AND shipment_header_id = p_ship_head_id
6425: AND EXISTS(

Line 6652: FROM rcv_shipment_lines rsl

6648: Id, Requisition #, To Organization Id and Item ID
6649: */
6650: SELECT DISTINCT rsl.from_organization_id
6651: INTO l_from_org_id
6652: FROM rcv_shipment_lines rsl
6653: WHERE item_id = p_item_id
6654: AND to_organization_id = p_to_org_id
6655: AND shipment_header_id = p_ship_head_id
6656: AND EXISTS(

Line 6754: FROM po_distributions_all pod, rcv_shipment_lines rsl

6750: ELSIF p_document_type = 'ASN' THEN
6751: BEGIN
6752: SELECT pod.task_id
6753: INTO l_task_id
6754: FROM po_distributions_all pod, rcv_shipment_lines rsl
6755: WHERE pod.po_header_id = rsl.po_header_id
6756: AND rsl.po_line_id = pod.po_line_id(+)
6757: AND rsl.po_line_location_id = pod.line_location_id(+)
6758: AND rsl.shipment_header_id = p_shipment_header_id

Line 7419: FROM rcv_shipment_lines rsl

7415: START WITH wlpn2.lpn_id = wlpn1.lpn_id
7416: CONNECT BY PRIOR wlpn2.lpn_id = wlpn2.parent_lpn_id
7417: INTERSECT
7418: SELECT rsl.asn_lpn_id
7419: FROM rcv_shipment_lines rsl
7420: WHERE rsl.shipment_header_id = rsh.shipment_header_id
7421: AND NOT exists (SELECT 1
7422: FROM rcv_transactions_interface rti
7423: WHERE rti.lpn_id = rsl.asn_lpn_id

Line 7584: FROM rcv_shipment_lines rsl, po_requisition_lines prl

7580: END IF;
7581: BEGIN
7582: SELECT count(DISTINCT rsl.shipment_header_id)
7583: INTO x_open_shipments
7584: FROM rcv_shipment_lines rsl, po_requisition_lines prl
7585: WHERE to_organization_id = p_organization_id
7586: AND nvl(rsl.shipment_line_status_code, ' ') <> 'FULLY RECEIVED'
7587: AND prl.requisition_header_id = p_requisition_header_id
7588: AND rsl.requisition_line_id = prl.requisition_line_id;

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

7636: l_progress := '20';
7637: BEGIN
7638: SELECT DISTINCT mum.uom_code
7639: INTO l_uom_code
7640: FROM rcv_transactions rt , rcv_shipment_lines rsl, mtl_units_of_measure mum
7641: WHERE rt.transaction_type = 'RECEIVE'
7642: AND rsl.item_id = p_item_id
7643: AND rt.organization_id = p_organization_id
7644: AND rsl.shipment_header_id = rt.shipment_header_id