APPS.CSTPPACQ dependencies on AP_INVOICES_ALL

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

950: -- J Changes -----------------------------------------------------------
951: RCV_TRANSACTIONS RT,
952: PO_LINES_ALL POL,
953: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
954: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */
955: ------------------------------------------------------------------------
956: WHERE
957: ad2.rcv_transaction_id = c_rec.transaction_id
958: AND ad2.posted_flag = 'Y'

Line 990: AP_INVOICES_ALL AP_INV

986: AIDA.line_type_lookup_code,
987: NVL(AIDA.BASE_AMOUNT, NVL(AIDA.AMOUNT, 0)) correction_amount
988:
989: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
990: AP_INVOICES_ALL AP_INV
991: /* Invoice Lines Project
992: No root_distribution_id or xinv_parent_reversal_id
993: now it'll just be represented by corrected_invoice_dist_id
994: */

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

2784: -- J Changes -----------------------------------------------------------
2785: RCV_TRANSACTIONS RT,
2786: PO_LINES_ALL POL,
2787: PO_LINE_LOCATIONS_ALL POLL, -- Added for Complex work Procurement
2788: ap_invoices_all aia /* bug 4352624 Added to ignore invoices of type prepayment */
2789: ------------------------------------------------------------------------
2790: WHERE
2791: ad2.rcv_transaction_id = l_rec_transaction_id
2792: AND ad2.posted_flag = 'Y'

Line 2819: AP_INVOICES_ALL AP_INV

2815: SELECT AIDA.invoice_distribution_id,
2816: AIDA.line_type_lookup_code,
2817: NVL(AIDA.BASE_AMOUNT, NVL(AIDA.AMOUNT, 0)) correction_amount
2818: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
2819: AP_INVOICES_ALL AP_INV
2820: /* Invoice Lines Project
2821: No root_distribution_id or xinv_parent_reversal_id
2822: now it'll just be represented by corrected_invoice_dist_id
2823: */