Conversions Scripts

[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

[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

[ahmadbilal]

simply query all_objects where object_type = 'TABLE' and Object_name like %interface%

[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