APPS.CSE_IPV_FA_PKG dependencies on AP_INVOICE_LINES_ALL

Line 593: ap_invoice_lines_all aila,

589: aila.inventory_item_id,
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')

Line 606: FROM ap_invoice_lines_all aila2

602: -- AND aila.inventory_item_id = nvl(p_inventory_item_id, aila.inventory_item_id)--Commented for bug 12991094
603: AND aia.invoice_id = aida.invoice_id
604: AND EXISTS ( --Added for bug 12991094
605: SELECT '1'
606: FROM ap_invoice_lines_all aila2
607: WHERE aila2.invoice_id = aila.invoice_id
608: AND aila2.inventory_item_id = nvl(p_inventory_item_id, aila2.inventory_item_id))
609: AND EXISTS (
610: SELECT '1'

Line 641: ap_invoice_lines_all aila,

637: aila.inventory_item_id,
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')

Line 652: FROM ap_invoice_lines_all aila2

648: AND aila.line_number = aida.invoice_line_number
649: AND aia.invoice_id = aida.invoice_id
650: AND EXISTS (
651: SELECT '1'
652: FROM ap_invoice_lines_all aila2
653: WHERE aila2.invoice_id = aila.invoice_id
654: AND aila2.inventory_item_id = nvl(p_inventory_item_id, aila2.inventory_item_id))
655: AND EXISTS (
656: SELECT '1'

Line 689: ap_invoice_lines_all aila,

685: aila.inventory_item_id,
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'

Line 701: FROM ap_invoice_lines_all aila2

697: AND aila.line_number = aida.invoice_line_number
698: AND aia.invoice_id = aida.invoice_id
699: AND EXISTS ( --Added for bug 12991094
700: SELECT '1'
701: FROM ap_invoice_lines_all aila2
702: WHERE aila2.invoice_id = aila.invoice_id
703: AND aila2.inventory_item_id = nvl(p_inventory_item_id, aila2.inventory_item_id))
704: /*
705: AND EXISTS (

Line 734: ap_invoice_lines_all aila,

730: aila.org_id,
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')

Line 745: FROM ap_invoice_lines_all aila2

741: AND aila.line_number = asstda.invoice_line_number
742: AND aia.invoice_id = asstda.invoice_id
743: AND EXISTS
744: (SELECT '1'
745: FROM ap_invoice_lines_all aila2
746: WHERE aila2.invoice_id = aila.invoice_id
747: AND aila2.inventory_item_id = NVL(p_inventory_item_id, aila2.inventory_item_id)
748: );
749: