View: AR_ADJ_DIST_UPG_V

Product:	AR - Receivables
Description:	AR XLA Extract
Implementation/DBA Data:	APPS.AR_ADJ_DIST_UPG_V

View Text

SELECT ARD.LINE_ID
, ARD.SOURCE_ID
, ARD.SOURCE_TABLE
, ARD.SOURCE_TYPE
, ARD.CODE_COMBINATION_ID
, ARD.AMOUNT_DR
, ARD.AMOUNT_CR
, ARD.ACCTD_AMOUNT_DR
, ARD.ACCTD_AMOUNT_CR
, ARD.ORG_ID
, ARD.SOURCE_TABLE_SECONDARY
, ARD.SOURCE_ID_SECONDARY
, ARD.CURRENCY_CODE
, ARD.CURRENCY_CONVERSION_RATE
, ARD.CURRENCY_CONVERSION_TYPE
, ARD.CURRENCY_CONVERSION_DATE
, ARD.TAXABLE_ENTERED_DR
, ARD.TAXABLE_ENTERED_CR
, ARD.TAXABLE_ACCOUNTED_DR
, ARD.TAXABLE_ACCOUNTED_CR
, ARD.TAX_LINK_ID
, ARD.THIRD_PARTY_ID
, ARD.THIRD_PARTY_SUB_ID
, ARD.REVERSED_SOURCE_ID
, ARD.TAX_CODE_ID
, ARD.LOCATION_SEGMENT_ID
, ARD.SOURCE_TYPE_SECONDARY
, ARD.TAX_GROUP_CODE_ID
, ARD.REF_CUSTOMER_TRX_LINE_ID
, ARD.REF_CUST_TRX_LINE_GL_DIST_ID
, ARD.REF_LINE_ID
, ARD.REF_ACCOUNT_CLASS
, ARD.ACTIVITY_BUCKET
, ARD.FROM_AMOUNT_DR
, ARD.FROM_AMOUNT_CR
, ARD.FROM_ACCTD_AMOUNT_DR
, ARD.FROM_ACCTD_AMOUNT_CR
, ARD.REF_DIST_CCID
, 'AR_DISTRIBUTIONS'
, NVL(ARD.REF_MF_DIST_FLAG
, 'N')
FROM AR_DISTRIBUTIONS_ALL ARD
, AR_ADJUSTMENTS_ALL ADJ
WHERE ADJ.UPGRADE_METHOD IN ('R12'
, '11I'
, '11IMFAR')
AND ADJ.ADJUSTMENT_ID = ARD.SOURCE_ID
AND ARD.SOURCE_TABLE = 'ADJ' UNION SELECT AR_NUM_RAN_PKG.NUM_RANDOM
, PSD.ADJUSTMENT_ID
, 'ADJ'
, ADJ.TYPE
, PSD.MF_ADJUSTMENT_CCID
, DECODE(SIGN(PSD.AMOUNT)
, -1
, ABS(PSD.AMOUNT)
, NULL)
, DECODE(SIGN(PSD.AMOUNT)
, 1
, ABS(PSD.AMOUNT)
, NULL)
, DECODE(SIGN(PSD.AMOUNT)
, -1
, ABS(PSD.AMOUNT)
, NULL)
, DECODE(SIGN(PSD.AMOUNT)
, 1
, ABS(PSD.AMOUNT)
, NULL)
, ADJ.ORG_ID
, NULL
, NULL
, TRX.INVOICE_CURRENCY_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, CTLGD.CUSTOMER_TRX_LINE_ID
, PSD.CUST_TRX_LINE_GL_DIST_ID
, NULL
, CTLGD.ACCOUNT_CLASS
, DECODE(CTLGD.ACCOUNT_CLASS
, 'REV'
, 'LINE'
, 'CB'
, 'LINE'
, 'TAX'
, 'TAX'
, 'FREIGHT'
, 'FREIGHT'
, 'LINE')
, NULL
, NULL
, NULL
, NULL
, PSD.MF_ADJUSTMENT_CCID
, 'PSA_MF_ADJ_DIST_ALL'
, 'Y'
FROM PSA_MF_ADJ_DIST_ALL PSD
, AR_ADJUSTMENTS_ALL ADJ
, RA_CUSTOMER_TRX_ALL TRX
, RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD
WHERE ADJ.UPGRADE_METHOD = '11IMFAR'
AND ADJ.ADJUSTMENT_ID = PSD.ADJUSTMENT_ID
AND NVL(PSD.AMOUNT
, 0) <> 0
AND ADJ.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND PSD.CUST_TRX_LINE_GL_DIST_ID = CTLGD.CUST_TRX_LINE_GL_DIST_ID

Columns