Page 1 of 1
Conversions Scripts
Posted: Mon Nov 20, 2006 3:13 am
by azeezpasha
Hi Friends
I am working as a Oracle Apps Technical consultant and i have beeen assigned the tasks of developing Scripts for Data Conversions, so if any body is having the scripts for the below mentioned modules please do the need ful help for me it will be appreciated
AR,AP,GL,FA,INV,PO,OM
Please send me the interface tables,base tables, scripts for the above modules its very very urgent.
Thanks in advance.
Regards,
Azeezpasha
Posted: Tue Dec 05, 2006 6:06 am
by amar.reddy
SOME OF THE INTERFACE AND BASE TABLES I KNOW
<u>GLINTERFACE TABLES:</u>
GL_INTERFACE
GL_INTERFACE_CONTROL
GL_INTERFAC_HISTORY
GL_IEA_INTERFACE
GL_DAILY_RATES_INTERFACE
GL_BUDGET_INTERFACE
<u>GL BASE TABLES</u>
GL_JE_HEADERS
GL_BUDGETS
GL_PERIODS
GL_JE_BATCHES
GL_JE_LINES
GL_SETS_OF_BOOKS
GL_CODE_COMBINATIONS
GL_BALANCES
GL_DAILY_BALANCES
<u>FOR AP:INTERFACE TABLES</u>
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE
AP BASE TABLES
AP_INVOICE_ALL
AP_INVOICE_PAYMENTS
AP_BANK_ACCOUNTS
AP_BANK_BRANCHES
AP_HOLDS
AP_PAYMENTS
AP_INVOICE_DISTRIBUTIONS_ALL
Posted: Wed Dec 06, 2006 3:25 am
by ahmadbilal
simply query all_objects where object_type = 'TABLE' and Object_name like %interface%
Posted: Mon Dec 18, 2006 11:01 am
by azeezpasha
[quote]SOME OF THE INTERFACE AND BASE TABLES I KNOW
<u>GLINTERFACE TABLES:</u>
GL_INTERFACE
GL_INTERFACE_CONTROL
GL_INTERFAC_HISTORY
GL_IEA_INTERFACE
GL_DAILY_RATES_INTERFACE
GL_BUDGET_INTERFACE
<u>GL BASE TABLES</u>
GL_JE_HEADERS
GL_BUDGETS
GL_PERIODS
GL_JE_BATCHES
GL_JE_LINES
GL_SETS_OF_BOOKS
GL_CODE_COMBINATIONS
GL_BALANCES
GL_DAILY_BALANCES
<u>FOR AP:INTERFACE TABLES</u>
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE
AP BASE TABLES
AP_INVOICE_ALL
AP_INVOICE_PAYMENTS
AP_BANK_ACCOUNTS
AP_BANK_BRANCHES
AP_HOLDS
AP_PAYMENTS
AP_INVOICE_DISTRIBUTIONS_ALL
<i><div align="right">Originally posted by amar.reddy