DBA Data[Home] [Help]

APPS.PA_FAXFACE dependencies on PO_HEADERS_ALL

Line 1524: po_headers_all POH ,

1520: FROM ap_invoices_all API ,
1521: ap_self_assessed_tax_dist_all sat,
1522: ap_batches_all APB ,
1523: po_vendors POV ,
1524: po_headers_all POH ,
1525: po_distributions_all POD
1526: /* Added _all for bug 9253946 */
1527: WHERE API.invoice_id = x_ref2
1528: AND sat.invoice_distribution_id = x_ref3 --bug 7428263

Line 1559: po_headers_all POH ,

1555: FROM ap_invoices_all API ,
1556: ap_invoice_distributions_all APID,
1557: ap_batches_all APB ,
1558: po_vendors POV ,
1559: po_headers_all POH ,
1560: po_distributions_all POD
1561: /* Added _all for bug 9253946 */
1562: WHERE API.invoice_id = x_ref2
1563: AND APID.invoice_distribution_id = x_ref3 --bug 7428263

Line 1592: po_headers_all POH /* Added _all for bug 9253946 */

1588: x_payables_batch_name
1589: from rcv_shipment_headers RCH,
1590: rcv_transactions RCV,
1591: po_vendors POV,
1592: po_headers_all POH /* Added _all for bug 9253946 */
1593: where RCV.po_header_id = x_ref2
1594: and RCV.po_distribution_id = x_ref4
1595: and RCV.transaction_id = x_ref3
1596: and RCV.po_header_id = POH.po_header_id