View: ARFV_ADJUSTMENT_DISTRIBUT_OLD1

View Text

SELECT /* UNIQUE ATTRIBUTES */ ADJ.ADJUSTMENT_ID
, /* REGULAR ATTRIBUTES */ '_LA:''ADJ'':AR_LOOKUPS:ACCOUNT_TYPE:MEANING'
, DIST.AMOUNT_DR
, DIST.AMOUNT_CR
, DIST.ACCTD_AMOUNT_DR
, DIST.ACCTD_AMOUNT_CR
, ADJ.GL_DATE
, '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE
, ''Y''
, ''Y''
, ''N''):AR_LOOKUPS:YES/NO:MEANING'
, /* RESOLVED FK RESOLUTIONS */ '_KF:SQLGL:GL#:GCC'
, AOU.NAME
, /* IDS */ DIST.CODE_COMBINATION_ID
, ADJ.ORG_ID
, /* WHO COLUMNS */ ADJ.LAST_UPDATE_DATE
, ADJ.LAST_UPDATED_BY
, ADJ.CREATION_DATE
, ADJ.CREATED_BY
FROM AR_ADJUSTMENTS_ALL ADJ
, AR_XLA_ARD_LINES_V DIST
, GL_CODE_COMBINATIONS GCC
, HR_ALL_ORGANIZATION_UNITS AOU
, XLA_AE_HEADERS HED
WHERE DIST.SOURCE_ID = ADJ.ADJUSTMENT_ID
AND DIST.SOURCE_TABLE = 'ADJ'
AND DIST.SOURCE_TYPE = 'ADJ'
AND DIST.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND ADJ.ORG_ID = AOU.ORGANIZATION_ID(+)
AND DIST.AE_HEADER_ID = HED.AE_HEADER_ID
AND '_SEC:ADJ.ORG_ID' IS NOT NULL WITH READ ONLY

Columns