Page 1 of 1
Interface Tables
Posted: Fri Apr 18, 2008 2:07 am
by mahesh123
Hi everybody
Can anybody tell me, what are mandatory Interface tables in GL,AP,AR.
Mahesh
91 9985220397
Posted: Fri Apr 18, 2008 4:42 am
by srinidavuluri
AP INTERFACE TABLE:
1). AP_INTERFACE_CONTROLS.
2). AP_INTERFACE_REJECTIONS
3). AP_INVOICE_INTERFACE
4). AP_INVOICE_LINES_INTERFACE.
AR INTERFACE TABLE:
1). AR_PAYMENTS_INTERFACE_ALL
2). AR_TAX_INTERFACE
3). HZ_PARTY_INTERFACE
4). HZ_PARTY_INTERFACE_ERRORS
5). RA_CUSTOMERS_INTERFACE_ALL
6). RA_INTERFACE_DISTRIBUTIONS_ALL
7). RA_INTERFACE_ERRORS_ALL
. RA_INTERFACE_LINES_ALL
9). RA_INTERFACE_SALESCREDITS_ALL
GL INTERFACE TABLE:
1). GL_BUDGET_INTERFACE
2). GL_DAILY_RATES_INTERFACE
3). GL_IEA_INTERFACE
4). GL_INTERFACE
5). GL_INTERFACE_CONTROL
6). GL_INTERFACE_HISTORY
Posted: Fri Apr 18, 2008 4:53 am
by admin
SELECT table_name
FROM all_tables
WHERE table_name LIKE '%INTERFACE%'
ORDER BY table_name