APPS.AP_TRIAL_BALANCE_PKG dependencies on AP_AE_LINES_ALL

Line 18: represents alias to ap_ae_lines_all.

14: reporting paramter.
15: p_org_where_alb - Multi ORG WHERE condition for cross org reporting
16: represents alias to ap_liability_balance.
17: p_org_where_ael - Multi ORG WHERE condition for cross org reporting
18: represents alias to ap_ae_lines_all.
19: p_org_where_asp - Multi ORG WHERE condition for cross org reporting
20: represents alias to ap_system_parameters_all.
21: p_neg_bal_only - Report on Negative Balances only parameter.
22: p_debug_switch - Debug Switch.

Line 215: ax_ap_ae_lines_all_v and ax_ap_ae_headers_all_v.

211: For AP the insert gets the information from the AP_LIABILITY_BALANCE. As of
212: now this table is populated only by AP, While transferring information to
213: GL.
214: For AX the insert gets the information from the AX views namely:
215: ax_ap_ae_lines_all_v and ax_ap_ae_headers_all_v.
216:
217: Note:
218: =====
219: 1) Trial Balance will report based on AP accounting data for all pre 11i

Line 418: || ' FROM ap_ae_lines_all ael, '

414: || ' aeh.set_of_books_id, '
415: || ' ai.invoice_id, '
416: || ' ai.invoice_amount, '
417: || ' NVL(ai.exchange_rate,1)) invoice_amount '
418: || ' FROM ap_ae_lines_all ael, '
419: || ' ap_ae_headers_all aeh, '
420: || ' ap_invoice_payments_all aip, '
421: || ' ap_invoices_all ai, '
422: || ' ap_system_parameters_all asp '

Line 463: || ' FROM ax_ap_ae_lines_all_v ael, '

459: || ' aeh.set_of_books_id, '
460: || ' ai.invoice_id, '
461: || ' ai.invoice_amount, '
462: || ' NVL(ai.exchange_rate,1)) invoice_amount '
463: || ' FROM ax_ap_ae_lines_all_v ael, '
464: || ' ax_ap_ae_headers_all_v aeh, '
465: || ' ap_invoice_payments_all aip, '
466: || ' ap_invoices_all ai, '
467: || ' ap_system_parameters_all asp '

Line 565: || ' FROM ap_ae_lines_all ael, '

561: || ' aeh.set_of_books_id, '
562: || ' ai.invoice_id, '
563: || ' ai.invoice_amount, '
564: || ' NVL(ai.exchange_rate,1)) invoice_amount '
565: || ' FROM ap_ae_lines_all ael, '
566: || ' ap_ae_headers_all aeh, '
567: || ' ap_invoice_payments_all aip, '
568: || ' ap_invoices_all ai, '
569: || ' ap_system_parameters_all asp '

Line 611: || ' FROM ax_ap_ae_lines_all_v ael, '

607: || ' aeh.set_of_books_id, '
608: || ' ai.invoice_id, '
609: || ' ai.invoice_amount, '
610: || ' NVL(ai.exchange_rate,1)) invoice_amount '
611: || ' FROM ax_ap_ae_lines_all_v ael, '
612: || ' ax_ap_ae_headers_all_v aeh, '
613: || ' ap_invoice_payments_all aip, '
614: || ' ap_invoices_all ai, '
615: || ' ap_system_parameters_all asp '

Line 792: from ap_ae_lines_all and ap_ae_headers_all for a given gl_transfer_run_id.

788:
789: 1) For a given request_id the function first determines the list of
790: gl_transfer_run_id from xla_gl_transfer_batches_all.
791: 2) Inserts the AP_LIABILITY_BALANCE with the denormalized information
792: from ap_ae_lines_all and ap_ae_headers_all for a given gl_transfer_run_id.
793: 3) Calls the Update trial_balance_flag of ap_ae_headers_all for the same
794: gl_transfer_run_id, so that we can make sure that accounting entry
795: lines of type LIABILITY associsted with the header record have been
796: transferred to the AP_LIABILITY_BALANCE table.

Line 902: ap_ae_lines_all ael,

898: p_program_appl_id,
899: p_program_id,
900: p_request_id
901: FROM ap_ae_headers_all aeh,
902: ap_ae_lines_all ael,
903: ap_accounting_events_all aae
904: WHERE aae.accounting_event_id = aeh.accounting_event_id
905: AND aeh.ae_header_id = ael.ae_header_id
906: AND ael.ae_line_type_code = 'LIABILITY'