View: ARFV_CASH_DISTRIBUTIONS

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

View Text

SELECT /* UNIQUE ATTRIBUTES */ DIST.LINE_ID
, /* REGULAR ATTRIBUTES */ '_LA:DECODE(DIST.SOURCE_TYPE
, ''CONFIRMATION''
, ''CONFIRMATION''
, ''REMITEMITTANCE''
, ''REMITTANCE''
, ''CASH''
, ''CASH''
, ''FACTOR''
, ''FACTOR''
, ''SHORT_TERM_DEBT''
, ''SHORT_TERM_DEBT''
, ''BANK_CHARGES''
, ''BANK_CHARGES''
, NULL):AR_LOOKUPS:ACCOUNT_TYPE:MEANING'
, DIST.AMOUNT_DR
, DIST.AMOUNT_CR
, DIST.ACCTD_AMOUNT_DR
, DIST.ACCTD_AMOUNT_CR
, CRH.GL_DATE
, '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE
, ''Y''
, ''Y''
, ''N''):AR_LOOKUPS:YES/NO:MEANING'
, /* RESOLVED FK RESOLUTIONS */ CR.RECEIPT_NUMBER
, AOU.NAME
, '_KF:SQLGL:GL#:GCC'
, /* IDS */ CRH.CASH_RECEIPT_ID
, CRH.ORG_ID
, DIST.CODE_COMBINATION_ID
, /* WHO COLUMNS */ DIST.LAST_UPDATE_DATE
, DIST.LAST_UPDATED_BY
, DIST.CREATION_DATE
, DIST.CREATED_BY
FROM AR_CASH_RECEIPT_HISTORY CRH
, AR_XLA_ARD_LINES_V DIST
, HR_ALL_ORGANIZATION_UNITS AOU
, AR_CASH_RECEIPTS CR
, GL_CODE_COMBINATIONS GCC
, XLA_AE_HEADERS HED
WHERE CRH.CASH_RECEIPT_HISTORY_ID = DIST.SOURCE_ID
AND DIST.SOURCE_TABLE = 'CRH'
AND CRH.ORG_ID = AOU.ORGANIZATION_ID(+)
AND CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
AND DIST.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND DIST.AE_HEADER_ID = HED.AE_HEADER_ID WITH READ ONLY

Columns