DBA Data[Home] [Help]

APPS.AP_WFAPPROVAL_PKG dependencies on PO_HEADERS

Line 829: po_headers poh

825: SELECT poh.segment1
826: INTO l_po_num
827: FROM ap_invoice_distributions aid,
828: po_distributions pod,
829: po_headers poh
830: WHERE aid.invoice_id = l_invoice_id
831: AND aid.po_distribution_id = pod.po_distribution_id
832: AND pod.po_header_id = poh.po_header_id;
833: ELSE

Line 1069: po_headers_all ph

1065: FROM per_all_people_f pap
1066: WHERE person_id = (SELECT ph.agent_id
1067: FROM ap_invoice_distributions_all aid,
1068: po_distributions_all pd,
1069: po_headers_all ph
1070: WHERE pd.po_distribution_id =
1071: aid.po_distribution_id
1072: AND pd.po_header_id = ph.po_header_id
1073: AND aid.invoice_distribution_id =