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 MTL_SUPPLY

Line 6344: FROM po_requisition_lines_all prl, mtl_supply ms

6340: CONNECT BY parent_lpn_id = PRIOR lpn_id)
6341: AND wlc.parent_lpn_id = wln.lpn_id
6342: AND EXISTS(
6343: SELECT 1
6344: FROM po_requisition_lines_all prl, mtl_supply ms
6345: WHERE prl.requisition_header_id = p_requiition_header_id
6346: AND prl.requisition_header_id = ms.req_header_id
6347: AND prl.requisition_line_id = ms.req_line_id
6348: AND ms.supply_type_code = 'SHIPMENT'

Line 6368: FROM po_requisition_lines_all prl, mtl_supply ms

6364: START WITH lpn_id = p_lpn_id
6365: CONNECT BY parent_lpn_id = PRIOR lpn_id)
6366: AND EXISTS(
6367: SELECT 1
6368: FROM po_requisition_lines_all prl, mtl_supply ms
6369: WHERE prl.requisition_header_id = p_requiition_header_id
6370: AND prl.requisition_header_id = ms.req_header_id
6371: AND prl.requisition_line_id = ms.req_line_id
6372: AND ms.supply_type_code = 'SHIPMENT'