[Home] [Help]
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
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 '
423: || ' WHERE ael.ae_line_type_code = ''FUTURE PAYMENT'' '
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 '
468: || ' WHERE ael.ae_line_type_code = ''FUTURE PAYMENT'' '
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 '
570: || ' WHERE ael.ae_line_type_code = ''FUTURE PAYMENT'' '
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 '
616: || ' WHERE ael.ae_line_type_code = ''FUTURE PAYMENT'' '
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.
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.
797:
815:
816: CURSOR transfer_info IS
817: SELECT DISTINCT (xgt.gl_transfer_run_id)
818: FROM xla_gl_transfer_batches_all xgt,
819: ap_ae_headers_all aeh
820: WHERE xgt.gl_transfer_run_id = aeh.gl_transfer_run_id
821: AND xgt.request_id = p_request_id
822: AND nvl(aeh.trial_balance_flag,'N') = 'N';
823:
897: SYSDATE,
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
963: fnd_file.put_line(fnd_file.log, 'Into Update_Trial_Balance_Flag Procedure');
964: fnd_file.put_line(fnd_file.log, 'Updating AE Headers for '
965: ||p_gl_transfer_run_id);
966:
967: UPDATE ap_ae_headers_all
968: SET trial_balance_flag = 'Y'
969: WHERE gl_transfer_run_id = p_gl_transfer_run_id;
970:
971: RETURN TRUE;