VIEW: APPS.ARBV_APPLICATION_DISTRIBUTIONS

Source

View Text - Preformatted

SELECT /* APPLICATION DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ RA.RECEIVABLE_APPLICATION_ID , '_LA:DECODE(RA.STATUS,   ''UNAPP'',   ''UNAPP'',   ''APP'',   ''REC'',   ''UNID'',   ''UNID'',   ''ACC'',   ''ACC'',   NULL):AR_LOOKUPS:ACCOUNT_TYPE:MEANING' , /* REGULAR ATTRIBUTES */ DIST.AMOUNT_DR, DIST.AMOUNT_CR, DIST.ACCTD_AMOUNT_DR, DIST.ACCTD_AMOUNT_CR, RA.GL_DATE , '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE,   ''Y'',   ''Y'',   ''N''):AR_LOOKUPS:YES/NO:MEANING' , /* RESOLVED FK RESOLUTIONS */ AOU.NAME , '_KF:SQLGL:GL#:GCC' , /* IDS */ RA.ORG_ID , DIST.CODE_COMBINATION_ID , /* WHO COLUMNS */ DIST.LAST_UPDATE_DATE , DIST.LAST_UPDATED_BY , DIST.CREATION_DATE , DIST.CREATED_BY FROM AR_RECEIVABLE_APPLICATIONS RA, AR_XLA_ARD_LINES_V DIST, HR_ALL_ORGANIZATION_UNITS AOU, GL_CODE_COMBINATIONS GCC, XLA_AE_HEADERS HED WHERE DIST.SOURCE_TYPE IN ('REC','UNAPP','UNID','ACC') AND DIST.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID AND DIST.SOURCE_TABLE = 'RA' AND RA.ORG_ID = AOU.ORGANIZATION_ID(+) AND DIST.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID AND DIST.AE_HEADER_ID = HED.AE_HEADER_ID UNION SELECT /* EARNED DISCOUNT DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ RA.RECEIVABLE_APPLICATION_ID, '_LA:''EDISC'':AR_LOOKUPS:ACCOUNT_TYPE:MEANING', /* REGULAR ATTRIBUTES */ DIST.AMOUNT_DR, DIST.AMOUNT_CR, DIST.ACCTD_AMOUNT_DR, DIST.ACCTD_AMOUNT_CR, RA.GL_DATE, '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE,   ''Y'',   ''Y'',   ''N''):AR_LOOKUPS:YES/NO:MEANING' , /* RESOLVED FK RESOLUTIONS */ AOU.NAME, '_KF:SQLGL:GL#:GCC', /* IDS */ RA.ORG_ID, DIST.CODE_COMBINATION_ID , /* WHO COLUMNS */ DIST.LAST_UPDATE_DATE, DIST.LAST_UPDATED_BY, DIST.CREATION_DATE, DIST.CREATED_BY FROM AR_RECEIVABLE_APPLICATIONS RA, AR_XLA_ARD_LINES_V DIST, HR_ALL_ORGANIZATION_UNITS AOU, GL_CODE_COMBINATIONS GCC , XLA_AE_HEADERS HED WHERE RA.EARNED_DISCOUNT_TAKEN IS NOT NULL AND RA.EARNED_DISCOUNT_TAKEN <> 0 AND DIST.SOURCE_TYPE IN ('EDISC') AND DIST.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID AND DIST.SOURCE_TABLE = 'RA' AND RA.ORG_ID = AOU.ORGANIZATION_ID(+) AND DIST.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID AND DIST.AE_HEADER_ID = HED.AE_HEADER_ID UNION SELECT /* UNEARNED DISCOUNT DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ RA.RECEIVABLE_APPLICATION_ID, '_LA:''UEDISC'':AR_LOOKUPS:ACCOUNT_TYPE:MEANING', /* REGULAR ATTRIBUTES */ DIST.AMOUNT_DR, DIST.AMOUNT_CR, DIST.ACCTD_AMOUNT_DR, DIST.ACCTD_AMOUNT_CR, RA.GL_DATE, '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE,   ''Y'',   ''Y'',   ''N''):AR_LOOKUPS:YES/NO:MEANING' , /* RESOLVED FK RESOLUTIONS */ AOU.NAME, '_KF:SQLGL:GL#:GCC', /* IDS */ RA.ORG_ID, DIST.CODE_COMBINATION_ID , /* WHO COLUMNS */ RA.LAST_UPDATE_DATE, RA.LAST_UPDATED_BY, RA.CREATION_DATE, RA.CREATED_BY FROM AR_RECEIVABLE_APPLICATIONS RA, AR_XLA_ARD_LINES_V DIST, HR_ALL_ORGANIZATION_UNITS AOU, GL_CODE_COMBINATIONS GCC , XLA_AE_HEADERS HED WHERE RA.UNEARNED_DISCOUNT_TAKEN IS NOT NULL AND RA.UNEARNED_DISCOUNT_TAKEN <> 0 AND DIST.SOURCE_TYPE IN ('UNEDISC') AND DIST.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID AND DIST.SOURCE_TABLE = 'RA' AND RA.ORG_ID = AOU.ORGANIZATION_ID(+) AND DIST.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID AND DIST.AE_HEADER_ID = HED.AE_HEADER_ID UNION SELECT /* EXCHANGE GAIN/LOSS DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ RA.RECEIVABLE_APPLICATION_ID, '_LA:''UEDISC'':AR_LOOKUPS:ACCOUNT_TYPE:MEANING', /* REGULAR ATTRIBUTES */ DIST.AMOUNT_DR, DIST.AMOUNT_CR, DIST.ACCTD_AMOUNT_DR, DIST.ACCTD_AMOUNT_CR, RA.GL_DATE, '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE,   ''Y'',   ''Y'',   ''N''):AR_LOOKUPS:YES/NO:MEANING' , /* RESOLVED FK RESOLUTIONS */ AOU.NAME, '_KF:SQLGL:GL#:GCC', /* IDS */ RA.ORG_ID, DIST.CODE_COMBINATION_ID , /* WHO COLUMNS */ RA.LAST_UPDATE_DATE, RA.LAST_UPDATED_BY, RA.CREATION_DATE, RA.CREATED_BY FROM AR_RECEIVABLE_APPLICATIONS RA, AR_XLA_ARD_LINES_V DIST, HR_ALL_ORGANIZATION_UNITS AOU, GL_CODE_COMBINATIONS GCC , XLA_AE_HEADERS HED WHERE RA.UNEARNED_DISCOUNT_TAKEN IS NOT NULL AND RA.UNEARNED_DISCOUNT_TAKEN <> 0 AND DIST.SOURCE_TYPE IN ('EXCH_GAIN','EXCH_LOSS') AND DIST.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID AND DIST.SOURCE_TABLE = 'RA' AND RA.ORG_ID = AOU.ORGANIZATION_ID(+) AND DIST.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID AND DIST.AE_HEADER_ID = HED.AE_HEADER_ID WITH READ ONLY

View Text - HTML Formatted

SELECT /* APPLICATION DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ RA.RECEIVABLE_APPLICATION_ID
, '_LA:DECODE(RA.STATUS
, ''UNAPP''
, ''UNAPP''
, ''APP''
, ''REC''
, ''UNID''
, ''UNID''
, ''ACC''
, ''ACC''
, NULL):AR_LOOKUPS:ACCOUNT_TYPE:MEANING'
, /* REGULAR ATTRIBUTES */ DIST.AMOUNT_DR
, DIST.AMOUNT_CR
, DIST.ACCTD_AMOUNT_DR
, DIST.ACCTD_AMOUNT_CR
, RA.GL_DATE
, '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE
, ''Y''
, ''Y''
, ''N''):AR_LOOKUPS:YES/NO:MEANING'
, /* RESOLVED FK RESOLUTIONS */ AOU.NAME
, '_KF:SQLGL:GL#:GCC'
, /* IDS */ RA.ORG_ID
, DIST.CODE_COMBINATION_ID
, /* WHO COLUMNS */ DIST.LAST_UPDATE_DATE
, DIST.LAST_UPDATED_BY
, DIST.CREATION_DATE
, DIST.CREATED_BY
FROM AR_RECEIVABLE_APPLICATIONS RA
, AR_XLA_ARD_LINES_V DIST
, HR_ALL_ORGANIZATION_UNITS AOU
, GL_CODE_COMBINATIONS GCC
, XLA_AE_HEADERS HED
WHERE DIST.SOURCE_TYPE IN ('REC'
, 'UNAPP'
, 'UNID'
, 'ACC')
AND DIST.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID
AND DIST.SOURCE_TABLE = 'RA'
AND RA.ORG_ID = AOU.ORGANIZATION_ID(+)
AND DIST.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND DIST.AE_HEADER_ID = HED.AE_HEADER_ID UNION SELECT /* EARNED DISCOUNT DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ RA.RECEIVABLE_APPLICATION_ID
, '_LA:''EDISC'':AR_LOOKUPS:ACCOUNT_TYPE:MEANING'
, /* REGULAR ATTRIBUTES */ DIST.AMOUNT_DR
, DIST.AMOUNT_CR
, DIST.ACCTD_AMOUNT_DR
, DIST.ACCTD_AMOUNT_CR
, RA.GL_DATE
, '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE
, ''Y''
, ''Y''
, ''N''):AR_LOOKUPS:YES/NO:MEANING'
, /* RESOLVED FK RESOLUTIONS */ AOU.NAME
, '_KF:SQLGL:GL#:GCC'
, /* IDS */ RA.ORG_ID
, DIST.CODE_COMBINATION_ID
, /* WHO COLUMNS */ DIST.LAST_UPDATE_DATE
, DIST.LAST_UPDATED_BY
, DIST.CREATION_DATE
, DIST.CREATED_BY
FROM AR_RECEIVABLE_APPLICATIONS RA
, AR_XLA_ARD_LINES_V DIST
, HR_ALL_ORGANIZATION_UNITS AOU
, GL_CODE_COMBINATIONS GCC
, XLA_AE_HEADERS HED
WHERE RA.EARNED_DISCOUNT_TAKEN IS NOT NULL
AND RA.EARNED_DISCOUNT_TAKEN <> 0
AND DIST.SOURCE_TYPE IN ('EDISC')
AND DIST.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID
AND DIST.SOURCE_TABLE = 'RA'
AND RA.ORG_ID = AOU.ORGANIZATION_ID(+)
AND DIST.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND DIST.AE_HEADER_ID = HED.AE_HEADER_ID UNION SELECT /* UNEARNED DISCOUNT DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ RA.RECEIVABLE_APPLICATION_ID
, '_LA:''UEDISC'':AR_LOOKUPS:ACCOUNT_TYPE:MEANING'
, /* REGULAR ATTRIBUTES */ DIST.AMOUNT_DR
, DIST.AMOUNT_CR
, DIST.ACCTD_AMOUNT_DR
, DIST.ACCTD_AMOUNT_CR
, RA.GL_DATE
, '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE
, ''Y''
, ''Y''
, ''N''):AR_LOOKUPS:YES/NO:MEANING'
, /* RESOLVED FK RESOLUTIONS */ AOU.NAME
, '_KF:SQLGL:GL#:GCC'
, /* IDS */ RA.ORG_ID
, DIST.CODE_COMBINATION_ID
, /* WHO COLUMNS */ RA.LAST_UPDATE_DATE
, RA.LAST_UPDATED_BY
, RA.CREATION_DATE
, RA.CREATED_BY
FROM AR_RECEIVABLE_APPLICATIONS RA
, AR_XLA_ARD_LINES_V DIST
, HR_ALL_ORGANIZATION_UNITS AOU
, GL_CODE_COMBINATIONS GCC
, XLA_AE_HEADERS HED
WHERE RA.UNEARNED_DISCOUNT_TAKEN IS NOT NULL
AND RA.UNEARNED_DISCOUNT_TAKEN <> 0
AND DIST.SOURCE_TYPE IN ('UNEDISC')
AND DIST.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID
AND DIST.SOURCE_TABLE = 'RA'
AND RA.ORG_ID = AOU.ORGANIZATION_ID(+)
AND DIST.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND DIST.AE_HEADER_ID = HED.AE_HEADER_ID UNION SELECT /* EXCHANGE GAIN/LOSS DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ RA.RECEIVABLE_APPLICATION_ID
, '_LA:''UEDISC'':AR_LOOKUPS:ACCOUNT_TYPE:MEANING'
, /* REGULAR ATTRIBUTES */ DIST.AMOUNT_DR
, DIST.AMOUNT_CR
, DIST.ACCTD_AMOUNT_DR
, DIST.ACCTD_AMOUNT_CR
, RA.GL_DATE
, '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE
, ''Y''
, ''Y''
, ''N''):AR_LOOKUPS:YES/NO:MEANING'
, /* RESOLVED FK RESOLUTIONS */ AOU.NAME
, '_KF:SQLGL:GL#:GCC'
, /* IDS */ RA.ORG_ID
, DIST.CODE_COMBINATION_ID
, /* WHO COLUMNS */ RA.LAST_UPDATE_DATE
, RA.LAST_UPDATED_BY
, RA.CREATION_DATE
, RA.CREATED_BY
FROM AR_RECEIVABLE_APPLICATIONS RA
, AR_XLA_ARD_LINES_V DIST
, HR_ALL_ORGANIZATION_UNITS AOU
, GL_CODE_COMBINATIONS GCC
, XLA_AE_HEADERS HED
WHERE RA.UNEARNED_DISCOUNT_TAKEN IS NOT NULL
AND RA.UNEARNED_DISCOUNT_TAKEN <> 0
AND DIST.SOURCE_TYPE IN ('EXCH_GAIN'
, 'EXCH_LOSS')
AND DIST.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID
AND DIST.SOURCE_TABLE = 'RA'
AND RA.ORG_ID = AOU.ORGANIZATION_ID(+)
AND DIST.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND DIST.AE_HEADER_ID = HED.AE_HEADER_ID WITH READ ONLY