VIEW: APPS.ARFV_INVOICE_ADJUSTMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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