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_HEADERS_ALL

Line 2502: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

2498: l_log_head CONSTANT varchar2(240) := g_pkg_name || l_api_name;
2499: l_progress VARCHAR2(3) := '000';
2500: l_action VARCHAR2(30);
2501: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2502: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2503: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
2504: l_po_return_code VARCHAR2(10);
2505: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
2506:

Line 3166: l_po_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;

3162: -- bug 3518116
3163: l_action VARCHAR2(30);
3164: l_doc_id_tbl po_tbl_number;
3165: --
3166: l_po_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3167: l_req_document_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%type;
3168: l_rel_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3169: l_return_status VARCHAR2(1);
3170: --Bug 11665915 Custom hook to validate funds in an external financial system - variables

Line 3168: l_rel_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;

3164: l_doc_id_tbl po_tbl_number;
3165: --
3166: l_po_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3167: l_req_document_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%type;
3168: l_rel_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3169: l_return_status VARCHAR2(1);
3170: --Bug 11665915 Custom hook to validate funds in an external financial system - variables
3171:
3172: l_ext_gl_return_code varchar2(1);

Line 4484: -- PO_HEADERS_ALL

4480: -- None.
4481: --Modifies:
4482: -- PO_ENCUMBRANCE_GT
4483: --Locks:
4484: -- PO_HEADERS_ALL
4485: -- PO_RELEASES_ALL
4486: -- PO_DISTRIBUTIONS_ALL
4487: -- PO_REQUISITION_HEADERS_ALL
4488: -- PO_REQ_DISTRIBUTIONS_ALL

Line 4896: , PO_HEADERS_ALL POH

4892: FROM
4893: PO_DISTRIBUTIONS_ALL POD
4894: , PO_LINE_LOCATIONS_ALL POLL
4895: , PO_LINES_ALL POL
4896: , PO_HEADERS_ALL POH
4897: , PO_SESSION_GT DIST_IDS
4898: WHERE POH.po_header_id = POD.po_header_id --JOIN
4899: AND POL.po_line_id(+) = POD.po_line_id --JOIN
4900: -- the distributions of PAs don't have associated lines