View: ARFV_UNREC_DISTRIBUTIONS

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.ARFV_UNREC_DISTRIBUTIONS

View Text

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'
, '_DF:AR:RA_CUST_TRX_LINE_GL_DIST:TLGD'
, /* RESOLVED FK RESOLUTIONS */ CT.TRX_NUMBER
, CTL.LINE_NUMBER
, '_KF:SQLGL:GL#:GCC'
, AOU.NAME
, /* 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
, RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX_LINES CTL
, GL_CODE_COMBINATIONS GCC
, HR_ALL_ORGANIZATION_UNITS AOU
, XLA_AE_HEADERS HED
WHERE TLGD.ACCOUNT_CLASS = 'UNBILL'
AND TLGD.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID (+)
AND TLGD.CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID (+)
AND TLGD.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND TLGD.ORG_ID = AOU.ORGANIZATION_ID(+)
AND TLGD.AE_HEADER_ID = HED.AE_HEADER_ID WITH READ ONLY

Columns