APPS.CSE_IPV_FA_PKG dependencies on AP_INVOICES_ALL

Line 65: from ap_invoices_all aia,

61: aida.distribution_line_number distribution_line_number,
62: aida.quantity_invoiced quantity_invoiced,
63: aida.base_invoice_price_variance base_invoice_price_variance,
64: cte.error_text error_text
65: from ap_invoices_all aia,
66: ap_invoice_distributions_all aida,
67: csi_txn_errors cte
68: where aida.invoice_id = aia.invoice_id
69: and cte.source_id = aida.invoice_distribution_id

Line 594: ap_invoices_all aia

590: aila.org_id,
591: 'N' as self_assessed_flag
592: FROM ap_invoice_distributions_all aida,
593: ap_invoice_lines_all aila,
594: ap_invoices_all aia
595: WHERE aida.line_type_lookup_code IN ('IPV','FREIGHT', 'NONREC_TAX', 'TRV','TIPV','ERV') --Modified for bug 12991094,13770784 and 13647752
596: AND aida.posted_flag = 'Y'
597: AND aida.assets_addition_flag IN ('U','I','N')
598: --AND NVL(aida.assets_tracking_flag,'x') = 'Y'

Line 642: ap_invoices_all aia

638: aila.org_id,
639: 'N' as self_assessed_flag
640: FROM ap_invoice_distributions_all aida,
641: ap_invoice_lines_all aila,
642: ap_invoices_all aia
643: WHERE aida.line_type_lookup_code IN ('FREIGHT')
644: AND aida.posted_flag = 'Y'
645: AND aida.assets_addition_flag IN ('U','I','N')
646: AND aida.po_distribution_id is null

Line 690: ap_invoices_all aia

686: aila.org_id,
687: 'N' as self_assessed_flag
688: FROM ap_invoice_distributions_all aida,
689: ap_invoice_lines_all aila,
690: ap_invoices_all aia
691: WHERE aida.line_type_lookup_code IN ('NONREC_TAX')
692: --WHERE aida.line_type_lookup_code IN ('NONREC_TAX', 'TRV','TIPV','ERV')
693: AND aida.posted_flag = 'Y'
694: AND aida.assets_addition_flag IN ('U','I','N')

Line 735: ap_invoices_all aia

731: asstda.SELF_ASSESSED_FLAG as self_assessed_flag
732: FROM AP_SELF_ASSESSED_TAX_DIST_all asstda,
733: --ap_invoice_distributions_all aida,
734: ap_invoice_lines_all aila,
735: ap_invoices_all aia
736: WHERE asstda.line_type_lookup_code IN ('NONREC_TAX')
737: AND asstda.posted_flag = 'Y'
738: AND asstda.assets_addition_flag IN ('U','I','N')
739: --AND asstda.po_distribution_id is null

Line 774: ap_invoices_all aia

770: nvl(aida.amount,0) base_amount,
771: aida.accounting_date,
772: aida.dist_code_combination_id inv_dist_ccid
773: FROM ap_invoice_distributions_all aida,
774: ap_invoices_all aia
775: WHERE aida.invoice_id = p_invoice_id
776: AND aida.project_id = p_project_id
777: AND aida.task_id = p_task_id
778: AND aida.line_type_lookup_code IN ('FREIGHT', 'TAX', 'NONREC_TAX','TRV','TIPV','ERV')