FB AutoAddFriends + UID Grabber 468x60

Friday, April 29, 2016

AR Table Relation Oracle Apps

ORACLE RECEIVABLE TABLE RELATION

Source Table

Dependent Table

Condition

RA_CUSTOMER_TRX_ALL

XLA_TRANSACTION_ENTITIES

xla.APPLICATION_ID = 222

xla.SOURCE_ID_INT_1 = ra.CUSTOMER_TRX_ID

xla.ENTITY_CODE = 'TRANSACTIONS

RA_CUSTOMER_TRX_ALL

XLA_TRANSACTION_ENTITIES

xla.APPLICATION_ID = 222 xla.SOURCE_ID_INT_1 =

ra.CUSTOMER_TRX_ID

xla.ENTITY_CODE = BILLS_RECEIVABLE'

AR_CASH_RECEIPTS_ALL

XLA_TRANSACTION_ENTITIES

xla.APPLICATION_ID = 222 xla.SOURCE_ID_INT_1 =

ar.CASH_RECEIPT_ID

xla.ENTITY_CODE = 'RECEIPTS'

AR_ADJUSTMENTS_ALL

XLA_TRANSACTION_ENTITIES

xla.APPLICATION_ID = 222 xla.SOURCE_ID_INT_1 =

ar.CASH_RECEIPT_ID

xla.ENTITY_CODE ='ADJUSTMENTS'

RA_CUST_TRX_LINE_GL_DIST_ALL

XLA_EVENTS

xla.APPLICATION_ID = 222

ra.EVENT_ID = xla.EVENT_ID

AR_CASH_RECEIPT_HISTORY_ALL

XLA_EVENTS

xla.APPLICATION_ID = 222

ra.EVENT_ID = xla.EVENT_ID

AR_RECEIVABLE_APPLICATIONS_ALL

XLA_EVENTS

xla.APPLICATION_ID = 222

ra.EVENT_ID = xla.EVENT_ID

AR_ADJUSTMENTS_ALL

XLA_EVENTS

xla.APPLICATION_ID = 222

ra.EVENT_ID = xla.EVENT_ID

AR_TRANSACTION_HISTORY_ALL

XLA_EVENTS

xla.APPLICATION_ID = 222

ra.EVENT_ID = xla.EVENT_ID

AR_MISC_CASH_DISTRIBUTIONS_ALL

XLA_EVENTS

xla.APPLICATION_ID = 222

ra.EVENT_ID = xla.EVENT_ID

 

1 comment:

Anonymous said...

I cannot thank lemeridian funding service enough and letting people know how grateful I am for all the assistance that you and your team staff have provided and I look forward to recommending friends and family should they need financial advice or assistance @ 1,9% Rate for Business Loan .Via Contact : . lfdsloans@lemeridianfds.com / lfdsloans@outlook.com. WhatsApp...+ 19893943740. Keep up the great work.
Thanks, Busarakham.