DBA Data[Home] [Help]

APPS.AP_IAW_PKG dependencies on PO_HEADERS_ALL

Line 3427: po_headers_all ph

3423: FROM per_all_people_f pap
3424: WHERE person_id = (SELECT ph.agent_id
3425: FROM ap_invoice_distributions_all aid,
3426: po_distributions_all pd,
3427: po_headers_all ph
3428: WHERE pd.po_distribution_id =
3429: aid.po_distribution_id
3430: AND pd.po_header_id = ph.po_header_id
3431: AND aid.invoice_distribution_id =

Line 3968: l_po_header_id po_headers_all.po_header_id%TYPE;

3964: actid IN NUMBER,
3965: funcmode IN VARCHAR2,
3966: resultout OUT NOCOPY VARCHAR2) AS
3967:
3968: l_po_header_id po_headers_all.po_header_id%TYPE;
3969: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
3970: l_invoice_id ap_invoices_all.invoice_id%TYPE;
3971: l_invoice_iteration ap_apinv_approvers.invoice_iteration%TYPE;
3972: l_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;

Line 4015: po_headers_all ph,

4011: -- 2. po buyers
4012: cursor buyers_csr is
4013: select ph.agent_id, ail.line_number, wfr.name
4014: from ap_invoice_lines_all ail,
4015: po_headers_all ph,
4016: ap_invoices_all ai,
4017: wf_local_roles wfr
4018: where ai.invoice_id = l_invoice_id
4019: and ai.invoice_id = ail.invoice_id