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_ALL

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