DBA Data[Home] [Help]

APPS.CSTPPACQ dependencies on AP_INVOICES_ALL

Line 947: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */

943: -- J Changes -----------------------------------------------------------
944: RCV_TRANSACTIONS RT,
945: PO_LINES_ALL POL,
946: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
947: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */
948: ------------------------------------------------------------------------
949: WHERE
950: ad2.rcv_transaction_id = c_rec.transaction_id
951: AND ad2.posted_flag = 'Y'

Line 1013: AP_INVOICES_ALL AP_INV

1009: INTO l_corr_invoice_id,
1010: l_corr_inv,
1011: l_correction_amount
1012: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
1013: AP_INVOICES_ALL AP_INV
1014: /* Invoice Lines Project
1015: No root_distribution_id or xinv_parent_reversal_id
1016: now it'll just be represented by corrected_invoice_dist_id
1017: */

Line 2740: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */

2736: -- J Changes -----------------------------------------------------------
2737: RCV_TRANSACTIONS RT,
2738: PO_LINES_ALL POL,
2739: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
2740: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */
2741: ------------------------------------------------------------------------
2742: WHERE
2743: ad2.rcv_transaction_id = c_rec.transaction_id
2744: AND ad2.posted_flag = 'Y'

Line 2804: AP_INVOICES_ALL AP_INV

2800: INTO l_corr_invoice_id,
2801: l_corr_inv,
2802: l_correction_amount
2803: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
2804: AP_INVOICES_ALL AP_INV
2805: /* Invoice Lines Project
2806: No root_distribution_id or xinv_parent_reversal_id
2807: now it'll just be represented by corrected_invoice_dist_id
2808: */