Product: | AR - Receivables |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.ARBV_UNREV_DISTRIBUTIONS |
SELECT /* UNIQUE ATTRIBUTES */ TLGD.CUST_TRX_LINE_GL_DIST_ID
, /* REGULAR ATTRIBUTES */ '_LA:TLGD.ACCOUNT_CLASS:AR_LOOKUPS:AUTOGL_TYPE:MEANING'
, DECODE(SIGN(TLGD.AMOUNT)
, -1
, ABS(TLGD.AMOUNT)
, NULL)
, DECODE(SIGN(TLGD.AMOUNT)
, 1
, TLGD.AMOUNT
, NULL)
, DECODE(SIGN(TLGD.ACCTD_AMOUNT)
, -1
, ABS(TLGD.ACCTD_AMOUNT)
, NULL)
, DECODE(SIGN(TLGD.ACCTD_AMOUNT)
, 1
, TLGD.ACCTD_AMOUNT
, NULL)
, TLGD.GL_DATE
, '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE
, ''Y''
, ''Y''
, ''N''):AR_LOOKUPS:YES/NO:MEANING'
, /* IDS */ TLGD.CUSTOMER_TRX_ID
, TLGD.CUSTOMER_TRX_LINE_ID
, TLGD.CODE_COMBINATION_ID
, TLGD.ORG_ID
, /* WHO COLUMNS */ TLGD.LAST_UPDATE_DATE
, TLGD.LAST_UPDATED_BY
, TLGD.CREATION_DATE
, TLGD.CREATED_BY
FROM AR_XLA_CTLGD_LINES_V TLGD
, XLA_AE_HEADERS HED
WHERE TLGD.ACCOUNT_CLASS = 'UNEARN'
AND TLGD.AE_HEADER_ID = HED.AE_HEADER_ID WITH READ ONLY