1-AP-应付教学教案.pptVIP

1.update gl_interface_control set status=I 2.update GL_INTERFACE set status =, accounted_dr = , accounted_cr = 3.insert into gl_je_lines FROM GL_INTERFACE 4.insert into gl_je_headers FROM GL_INTERFACE 5.insert into gl_je_batches FROM GL_INTERFACE 6.update gl_bc_packets from gl_je_batches b, gl_je_sources 7.insert into gl_import_references from GL_INTERFACE where status = PROCESSED 8X.delete from GL_INTERFACE where status = PROCESSED 9X.delete from gl_interface_control 1.????? 1.Create Invoice Ap_batches_all Ap_invoices_all invoice_id Ap_invoice_distributions_all Ap_chrg_allocations_all Ap_Payment_schedules_all 2.? Create Payment? Ap_invoice_payments_all Ap_checks_all 3. Accounting Ap_accounting_events_all Ap_ae_headers_all Ap_ae_lines_all 4. GL transferring GL_interface ? select a.APPLICATION_SHORT_NAME from fnd_application a, GL_PERIOD_STATUSES b where a.APPLICATION_ID=b.APPLICATION_ID; 1.UPDATE ap_ae_headers SET gl_transfer_error_code = NULL, gl_transfer_flag = Y WHERE gl_transfer_run_id = -1 AND gl_transfer_flag IN ( N,E) AND accounting_error_code IS NULL 2. UPDATE AP_AE_LINES_ALL SET gl_transfer_error_code = FROM ap_ae_headers , gl_code_combinations 3.UPDATE ap_ae_headers SET gl_transfer_run_id = -1, gl_transfer_flag = E 4.UPDATE ap_ae_lines SET program_update_date = Sysdate, gl_sl_link_id = ap_ae_link_id_s.NEXTVAL 5.INSERT INTO gl_interface FROM ap_ae_headers , ap_ae_lines , gl_je_categories 6.INSERT INTO GL_INTERFACE_CONTROL 7.INSERT INTO AP_LIABILITY_BALANCE FROM AP_AE_HEADERS_ALL ,AP_AE_LINES_ALL ,AP_ACCOUNTING_EVENTS_ALL Where AP_AE_LINES_ALL.AE_LINE_TYPE_CODE = LIABILITY AND AP_AE_HEADERS_ALL.GL_TRANSFER_FLAG = Y 8.UPDATE AP_AE_HEADERS_ALL SET TRIAL_BALANCE_FLAG=Y 1.UPDATE ap_ae_headers SET gl_transfer_error_code = NULL, gl_transfer_flag = Y