APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_INVOICES_ALL

Line 250: ap_invoices_all ai

246: ,aid.invoice_line_number
247: ,G_SRC_TYP_UNACCT_DISTS
248: ,G_SRC_TAB_AP_INV_DISTS_ALL
249: from
250: ap_invoices_all ai
251: ,ap_invoice_distributions_all aid
252: ,ap_org_attributes_gt org_gtt
253: where
254: ai.invoice_id = aid.invoice_id

Line 295: from ap_invoices_all ai

291: ,aid.detail_tax_dist_id
292: ,aid.invoice_line_number
293: ,G_SRC_TYP_UNACCT_DISTS
294: ,G_SRC_TAB_AP_INV_DISTS_ALL
295: from ap_invoices_all ai
296: ,ap_invoice_distributions_all aid
297: ,ap_org_attributes_gt org_gtt
298: where ai.invoice_id = aid.invoice_id
299: and ( aid.accounting_date between g_period_start_date and g_period_end_date)

Line 376: ap_invoices_all ai

372: ,astd.detail_tax_dist_id
373: ,G_SRC_TYP_UNACCT_DISTS
374: ,G_SRC_TAB_AP_SELF_TAX_DIST_ALL
375: from
376: ap_invoices_all ai
377: ,ap_self_assessed_tax_dist_all astd
378: ,ap_org_attributes_gt org_gtt
379: where
380: ai.invoice_id = astd.invoice_id

Line 413: ap_invoices_all ai

409: ,astd.detail_tax_dist_id
410: ,G_SRC_TYP_UNACCT_DISTS
411: ,G_SRC_TAB_AP_SELF_TAX_DIST_ALL
412: from
413: ap_invoices_all ai
414: ,ap_self_assessed_tax_dist_all astd
415: ,ap_org_attributes_gt org_gtt
416: where
417: ai.invoice_id = astd.invoice_id

Line 478: ap_invoices_all ai

474: ,ai.cancelled_date
475: ,G_SRC_TYP_LINES_WITHOUT_DISTS
476: ,G_SRC_TAB_AP_INV_LINES_ALL
477: from
478: ap_invoices_all ai
479: ,ap_invoice_lines_all ail
480: ,ap_org_attributes_gt org_gtt
481: where
482: ai.invoice_id = ail.invoice_id

Line 554: from ap_invoices_all ai

550: ,ai.cancelled_date
551: ,ai.legal_entity_id
552: ,G_SRC_TYP_UNACCT_PREPAY_HIST
553: ,G_SRC_TAB_AP_PREPAY_HIST
554: from ap_invoices_all ai
555: ,ap_prepay_history_all apph
556: ,ap_org_attributes_gt org_gtt
557: where
558: ai.invoice_id = apph.invoice_id

Line 800: ,(select party_id from ap_invoices_all

796: ,xla_headers_untransfered(i).event_type_code
797: ,xla_headers_untransfered(i).entity_code
798: ,G_SRC_TYP_UNTRANSFERED_HEADERS
799: ,G_SRC_TAB_XLA_AE_HEADERS
800: ,(select party_id from ap_invoices_all
801: where invoice_id = xla_headers_untransfered(i).source_id_int_1
802: and 'AP_INVOICES' = xla_headers_untransfered(i).entity_code
803: union
804: select party_id from ap_checks_all

Line 807: ,(select vendor_id from ap_invoices_all

803: union
804: select party_id from ap_checks_all
805: where check_id = xla_headers_untransfered(i).source_id_int_1
806: and 'AP_PAYMENTS' = xla_headers_untransfered(i).entity_code) /*Bug 9721897*/
807: ,(select vendor_id from ap_invoices_all
808: where invoice_id = xla_headers_untransfered(i).source_id_int_1
809: and 'AP_INVOICES' = xla_headers_untransfered(i).entity_code
810: union
811: select vendor_id from ap_checks_all

Line 884: FROM ap_invoices_all ai

880: ,xla_events_unacct(i).event_type_code
881: ,xla_events_unacct(i).entity_code
882: ,G_SRC_TYP_OTHER_EXCPS
883: ,G_SRC_TAB_AP_INV_DISTS_ALL
884: FROM ap_invoices_all ai
885: ,ap_invoice_distributions_all aid
886: ,ap_org_attributes_gt org_gtt
887: WHERE aid.invoice_id = ai.invoice_id(+)
888: AND aid.set_of_books_id = g_ledger_id

Line 917: FROM ap_invoices_all ai

913: ,xla_events_unacct(i).event_type_code
914: ,xla_events_unacct(i).entity_code
915: ,G_SRC_TYP_OTHER_EXCPS
916: ,G_SRC_TAB_AP_SELF_TAX_DIST_ALL
917: FROM ap_invoices_all ai
918: ,ap_self_assessed_tax_dist_all astd
919: ,ap_org_attributes_gt org_gtt
920: WHERE astd.invoice_id = ai.invoice_id(+)
921: AND astd.set_of_books_id = g_ledger_id

Line 950: FROM ap_invoices_all ai

946: ,xla_events_unacct(i).event_type_code
947: ,xla_events_unacct(i).entity_code
948: ,G_SRC_TYP_OTHER_EXCPS
949: ,G_SRC_TAB_AP_PREPAY_HIST
950: FROM ap_invoices_all ai
951: ,ap_prepay_history_all apph
952: ,ap_org_attributes_gt org_gtt
953: WHERE apph.invoice_id = ai.invoice_id(+)
954: AND apph.accounting_event_id IS NOT NULL

Line 1074: ,(select party_id from ap_invoices_all

1070: ,xla_events_unacct(i).event_type_code
1071: ,xla_events_unacct(i).entity_code
1072: ,G_SRC_TYP_OTHER_EXCPS
1073: ,'ORPHAN_EVENTS'
1074: ,(select party_id from ap_invoices_all
1075: where invoice_id = xla_events_unacct(i).source_id_int_1
1076: and 'AP_INVOICES' = xla_events_unacct(i).entity_code
1077: union
1078: select party_id from ap_checks_all

Line 1081: ,(select vendor_id from ap_invoices_all

1077: union
1078: select party_id from ap_checks_all
1079: where check_id = xla_events_unacct(i).source_id_int_1
1080: and 'AP_PAYMENTS' = xla_events_unacct(i).entity_code) party_id /*Bug 9721897*/
1081: ,(select vendor_id from ap_invoices_all
1082: where invoice_id = xla_events_unacct(i).source_id_int_1
1083: and 'AP_INVOICES' = xla_events_unacct(i).entity_code
1084: union
1085: select vendor_id from ap_checks_all