APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 3127: l_req_document_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%type;

3123: l_action VARCHAR2(30);
3124: l_doc_id_tbl po_tbl_number;
3125: --
3126: l_po_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3127: l_req_document_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%type;
3128: l_rel_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3129: l_return_status VARCHAR2(1);
3130:
3131:

Line 4287: -- PO_REQUISITION_HEADERS_ALL

4283: --Locks:
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

Line 4529: , PO_REQUISITION_HEADERS_ALL PRH

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
4532: AND PRL.requisition_line_id = PRD.requisition_line_id --JOIN
4533: AND PRD.distribution_id = DIST_IDS.num1 --JOIN