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_UI_RCV_LOVS dependencies on PO_REQUISITION_LINES

Line 762: po_requisition_lines prl,

758: to_char(prh.org_id) --
759: FROM
760: po_requisition_headers prh,
761: rcv_supply ms,
762: po_requisition_lines prl,
763: rcv_transactions rt
764: WHERE
765: prh.requisition_header_id = ms.req_header_id
766: AND prl.requisition_header_id = prh.requisition_header_id

Line 801: po_requisition_lines prl

797: null,
798: to_char(prh.org_id) --
799: FROM
800: po_requisition_headers prh,
801: po_requisition_lines prl
802: WHERE
803: Nvl(prl.cancel_flag,'N') = 'N'
804: AND prl.destination_organization_id = p_organization_id
805: AND prh.requisition_header_id = prl.requisition_header_id

Line 829: po_requisition_lines prl

825: null,
826: to_char(prh.org_id) --
827: FROM
828: po_requisition_headers prh,
829: po_requisition_lines prl
830: WHERE
831: Nvl(prl.cancel_flag,'N') = 'N'
832: AND prl.destination_organization_id = p_organization_id
833: AND prh.requisition_header_id = prl.requisition_header_id

Line 2353: po_requisition_lines prl

2349: lookup_code FIELD13 ,
2350: to_char(prh.org_id) FIELD14 --
2351: FROM fnd_lookup_values_vl flv,
2352: po_requisition_headers prh,
2353: po_requisition_lines prl
2354: WHERE flv.lookup_code = 'REQ'
2355: AND flv.lookup_type = 'DOC_TYPE'
2356: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2357: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2827: po_requisition_lines prl

2823: lookup_code FIELD13 ,
2824: to_char(prh.org_id) FIELD14 --
2825: FROM fnd_lookup_values_vl flv,
2826: po_requisition_headers prh,
2827: po_requisition_lines prl
2828: WHERE flv.lookup_code = 'REQ'
2829: AND flv.lookup_type = 'DOC_TYPE'
2830: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2831: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 6447: and exists (SELECT 1 FROM po_requisition_lines_all prl,

6443: from mtl_system_items_vl Bug 5581528
6444: WHERE organization_id = p_Organization_Id
6445: and concatenated_segments like p_concatenated_segments
6446: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
6447: and exists (SELECT 1 FROM po_requisition_lines_all prl,
6448: rcv_shipment_lines rsl , po_req_distributions_all prd
6449: WHERE prl.requisition_header_id = p_reqHeaderID
6450: and rsl.item_id = inventory_item_id
6451: and ( (l_from_lpn_id is null)

Line 6526: and exists (SELECT 1 FROM po_requisition_lines_all prl,

6522: and mcr.organization_id = p_organization_id
6523: ) )
6524: and mcr.inventory_item_id = msi.inventory_item_id
6525: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
6526: and exists (SELECT 1 FROM po_requisition_lines_all prl,
6527: rcv_shipment_lines rsl , po_req_distributions_all prd
6528: WHERE prl.requisition_header_id = p_reqHeaderID
6529: and rsl.item_id = msi.inventory_item_id
6530: and ( (l_from_lpn_id is null)

Line 6601: FROM po_Requisition_Lines_All prl,

6597: FROM mtl_system_items_vl,
6598: /* Bug 5581528 */
6599: (
6600: SELECT DISTINCT rsl.Item_Id
6601: FROM po_Requisition_Lines_All prl,
6602: rcv_Shipment_Lines rsl ,
6603: po_req_Distributions_All prd
6604: WHERE prl.Requisition_Header_Id = p_reqHeadeRid
6605: AND l_From_lpn_Id IS NOT NULL

Line 6681: FROM po_Requisition_Lines_All prl,

6677: FROM mtl_system_items_vl,
6678: /* Bug 5581528 */
6679: (
6680: SELECT DISTINCT rsl.Item_Id
6681: FROM po_Requisition_Lines_All prl,
6682: rcv_Shipment_Lines rsl ,
6683: po_req_Distributions_All prd
6684: WHERE prl.Requisition_Header_Id = p_reqHeadeRid
6685: AND l_From_lpn_Id IS NULL

Line 6766: FROM po_requisition_lines_all prl,

6762: AND (purchasing_enabled_flag = 'Y'
6763: OR stock_enabled_flag = 'Y')
6764: AND EXISTS
6765: (SELECT 1
6766: FROM po_requisition_lines_all prl,
6767: rcv_shipment_lines rsl ,
6768: po_req_distributions_all prd
6769: WHERE prl.requisition_header_id = p_reqHeaderID
6770: AND rsl.item_id = msi.inventory_item_id

Line 8137: AND msik.inventory_item_id IN (SELECT item_id FROM po_requisition_lines WHERE requisition_header_id = p_reqHeaderID )

8133: WHERE
8134: organization_id = p_Organization_Id
8135: AND concatenated_segments like p_concatenated_segments
8136: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
8137: AND msik.inventory_item_id IN (SELECT item_id FROM po_requisition_lines WHERE requisition_header_id = p_reqHeaderID )
8138: UNION
8139: select
8140: concatenated_segments,
8141: msik.inventory_item_id,

Line 8196: AND msik.inventory_item_id IN (SELECT item_id FROM po_requisition_lines WHERE requisition_header_id = p_reqHeaderID );

8192: AND mcr.cross_reference like g_crossref
8193: AND (mcr.organization_id = msik.organization_id
8194: OR mcr.org_independent_flag = 'Y' )
8195: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
8196: AND msik.inventory_item_id IN (SELECT item_id FROM po_requisition_lines WHERE requisition_header_id = p_reqHeaderID );
8197:
8198: ELSIF (p_oeOrderHeaderID IS NOT NULL ) THEN
8199: open x_items for
8200: SELECT