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_MAINTAIN_RESERVATION_PUB dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 3227: from po_requisition_lines_all prl, po_requisition_headers_all prh , po_req_distributions_all prd, mtl_units_of_measure muom

3223: , quantity
3224: , project_id
3225: , task_id
3226: , source_type_code
3227: from po_requisition_lines_all prl, po_requisition_headers_all prh , po_req_distributions_all prd, mtl_units_of_measure muom
3228: where prh.requisition_header_id = p_header_id
3229: and prh.REQUISITION_HEADER_ID = prl.REQUISITION_HEADER_ID
3230: and prd.requisition_line_id = prl.requisition_line_id
3231: and nvl(prl.modified_by_agent_flag,'N') <> 'Y'

Line 3304: , po_req_distributions_all b

3300: , Nvl(b.project_id,-99) project_id
3301: , Nvl(b.task_id, -99) task_id
3302: -- , sum(a.quantity_ordered) quantity_ordered
3303: FROM po_distributions_all a
3304: , po_req_distributions_all b
3305: WHERE a.line_location_id = v_po_shipment_id
3306: AND a.req_distribution_id = b.distribution_id
3307: AND a.distribution_type <> 'AGREEMENT' --
3308: GROUP BY b.requisition_line_id

Line 3544: , po_req_distributions_all c

3540: , c.task_id
3541: , d.requisition_header_id
3542: FROM rcv_transactions a
3543: , rcv_shipment_lines b
3544: , po_req_distributions_all c
3545: , po_requisition_lines_all d
3546: , mtl_units_of_measure e
3547: WHERE a.transaction_id = v_transaction_id
3548: AND a.source_document_code = 'REQ'