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.PO_DOCUMENT_FUNDS_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 3305: FROM PO_REQUISITION_LINES_ALL POL, PO_REQ_DISTRIBUTIONS_ALL POD

3301: FROM po_requisition_lines_all
3302: WHERE requisition_line_id = p_doc_level_id ;
3303: ELSIF p_doc_level='DISTRIBUTION' THEN
3304: SELECT requisition_header_id into l_req_document_id
3305: FROM PO_REQUISITION_LINES_ALL POL, PO_REQ_DISTRIBUTIONS_ALL POD
3306: WHERE POL.REQUISITION_LINE_ID = POD.REQUISITION_LINE_ID
3307: AND POD.DISTRIBUTION_ID =p_doc_level_id;
3308: END IF;
3309: END IF;

Line 4288: -- PO_REQ_DISTRIBUTIONS_ALL

4284: -- PO_HEADERS_ALL
4285: -- PO_RELEASES_ALL
4286: -- PO_DISTRIBUTIONS_ALL
4287: -- PO_REQUISITION_HEADERS_ALL
4288: -- PO_REQ_DISTRIBUTIONS_ALL
4289: --Function:
4290: -- Flattens the PO transaction tables to retrieve all of the
4291: -- data needed by the encumbrance code and put it in the
4292: -- encumbrance table. Also locks the document headers and

Line 4527: PO_REQ_DISTRIBUTIONS_ALL PRD

4523: , PRD.expenditure_organization_id
4524: , PRD.expenditure_item_date
4525: , PRL.vendor_id
4526: FROM
4527: PO_REQ_DISTRIBUTIONS_ALL PRD
4528: , PO_REQUISITION_LINES_ALL PRL
4529: , PO_REQUISITION_HEADERS_ALL PRH
4530: , PO_SESSION_GT DIST_IDS
4531: WHERE PRH.requisition_header_id = PRL.requisition_header_id --JOIN

Line 5224: from po_req_distributions_all prd,

5220:
5221: BEGIN
5222: select nvl(pod.encumbered_flag, 'N')
5223: into l_found
5224: from po_req_distributions_all prd,
5225: po_requisition_lines_all prl,
5226: po_distributions_all pod
5227: where prd.distribution_id = p_req_dist_id
5228: and prl.requisition_line_id = prd.requisition_line_id