View: ARFV_INVOICE_ADJUSTMENTS

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

View Text

SELECT /* UNIQUE ATTRIBUTES */ ADJ.ADJUSTMENT_ID
, /* REGULAR ATTRIBUTES */ ADJ.ADJUSTMENT_NUMBER
, RT.NAME
, '_LA:ADJ.TYPE:AR_LOOKUPS:ADJUSTMENT_TYPE:MEANING'
, ADJ.AMOUNT
, ADJ.GL_DATE
, ADJ.APPLY_DATE
, '_LA:ADJ.REASON_CODE:AR_LOOKUPS:ADJUST_REASON:MEANING'
, '_LA:ADJ.STATUS:AR_LOOKUPS:APPROVAL_TYPE:MEANING'
, ADJ.DOC_SEQUENCE_VALUE
, ADJ.LINE_ADJUSTED
, ADJ.TAX_ADJUSTED
, ADJ.FREIGHT_ADJUSTED
, ADJ.RECEIVABLES_CHARGES_ADJUSTED
, US.USER_NAME
, '_DF:AR:AR_ADJUSTMENTS:ADJ'
, /* RESOLVED FK RESOLUTIONS */ CR.RECEIPT_NUMBER
, '_KF:SQLGL:GL#:GCC'
, CT.TRX_NUMBER
, CTL.LINE_NUMBER
, CBCT.TRX_NUMBER
, AOU.NAME
, /* IDS */ ADJ.PAYMENT_SCHEDULE_ID
, ADJ.ASSOCIATED_CASH_RECEIPT_ID
, ADJ.ASSOCIATED_APPLICATION_ID
, DIST.CODE_COMBINATION_ID
, ADJ.CUSTOMER_TRX_ID
, ADJ.CUSTOMER_TRX_LINE_ID
, ADJ.CHARGEBACK_CUSTOMER_TRX_ID
, ADJ.RECEIVABLES_TRX_ID
, ADJ.ORG_ID
, /* WHO COLUMNS */ ADJ.LAST_UPDATE_DATE
, ADJ.LAST_UPDATED_BY
, ADJ.CREATION_DATE
, ADJ.CREATED_BY
FROM AR_ADJUSTMENTS ADJ
, AR_RECEIVABLES_TRX RT
, FND_USER US
, AR_CASH_RECEIPTS CR
, GL_CODE_COMBINATIONS GCC
, RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX_LINES CTL
, RA_CUSTOMER_TRX CBCT
, HR_ALL_ORGANIZATION_UNITS AOU
, AR_XLA_ARD_LINES_V DIST
, XLA_AE_HEADERS HED
WHERE ADJ.RECEIVABLES_TRX_ID = RT.RECEIVABLES_TRX_ID
AND ((ADJ.RECEIVABLES_TRX_ID IS NULL) OR (ADJ.RECEIVABLES_TRX_ID IS NOT NULL
AND NVL(ADJ.ORG_ID
, -12345) = NVL(RT.ORG_ID
, -12345)))
AND ADJ.APPROVED_BY = US.USER_ID (+)
AND ADJ.ASSOCIATED_CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID (+)
AND ADJ.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID (+)
AND NVL(ADJ.CODE_COMBINATION_ID
, -99) = DECODE(ADJ.CODE_COMBINATION_ID
, NULL
, -99
, GCC.CODE_COMBINATION_ID)
AND ADJ.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID (+)
AND ADJ.CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID (+)
AND ADJ.CHARGEBACK_CUSTOMER_TRX_ID = CBCT.CUSTOMER_TRX_ID (+)
AND ADJ.ORG_ID = AOU.ORGANIZATION_ID (+)
AND DIST.SOURCE_ID = ADJ.ADJUSTMENT_ID
AND DIST.SOURCE_TABLE = 'ADJ'
AND DIST.SOURCE_TYPE = 'ADJ'
AND DIST.AE_HEADER_ID = HED.AE_HEADER_ID WITH READ ONLY

Columns