FND Design Data [Home] [Help]

View: AR_APP_DIST_UPG_V

Product: AR - Receivables
Description: AR XLA extract
Implementation/DBA Data: ViewAPPS.AR_APP_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_RECEIVABLE_APPLICATIONS_ALL APP
WHERE APP.UPGRADE_METHOD IN ('R12_NLB'
, 'R12'
, 'R12_11IMFAR'
, 'R12_11ICASH')
AND APP.RECEIVABLE_APPLICATION_ID = ARD.SOURCE_ID
AND ARD.SOURCE_TABLE = 'RA' UNION SELECT ACB.CASH_BASIS_DISTRIBUTION_ID
, ACB.RECEIVABLE_APPLICATION_ID
, 'RA'
, DECODE(ACB.ACTIVITY_BUCKET
, 'ED_LINE'
, 'EDISC'
, 'UNED_LINE'
, 'UNEDISC'
, 'ED_TAX'
, 'EDISC'
, 'UNED_TAX'
, 'UNEDISC'
, 'ED_FRT'
, 'EDISC'
, 'UNED_FRT'
, 'UNEDISC'
, 'ED_CHRG'
, 'EDISC'
, 'UNED_CHRG'
, 'UNEDISC'
, 'REC')
, ACB.CODE_COMBINATION_ID
, DECODE(SIGN(ACB.AMOUNT)
, -1
, ABS(ACB.AMOUNT)
, NULL)
, DECODE(SIGN(ACB.AMOUNT)
, 1
, ABS(ACB.AMOUNT)
, NULL)
, DECODE(SIGN(ACB.AMOUNT)
, -1
, ABS(ACB.ACCTD_AMOUNT)
, NULL)
, DECODE(SIGN(ACB.AMOUNT)
, 1
, ABS(ACB.ACCTD_AMOUNT)
, NULL)
, ACB.ORG_ID
, NULL
, NULL
, ACB.CURRENCY_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, ACB.REF_CUSTOMER_TRX_LINE_ID
, ACB.REF_CUST_TRX_LINE_GL_DIST_ID
, ACB.REF_LINE_ID
, ACB.REF_ACCOUNT_CLASS
, ACB.ACTIVITY_BUCKET
, DECODE(SIGN(ACB.AMOUNT)
, -1
, ABS(ACB.AMOUNT)
, NULL)
, DECODE(SIGN(ACB.AMOUNT)
, 1
, ABS(ACB.AMOUNT)
, NULL)
, DECODE(SIGN(ACB.AMOUNT)
, -1
, ABS(ACB.ACCTD_AMOUNT)
, NULL)
, DECODE(SIGN(ACB.AMOUNT)
, 1
, ABS(ACB.ACCTD_AMOUNT)
, NULL)
, ACB.CODE_COMBINATION_ID
, 'AR_CASH_BASIS_DISTS_ALL'
, 'N'
FROM AR_CASH_BASIS_DISTS_ALL ACB
, AR_RECEIVABLE_APPLICATIONS_ALL APP
WHERE APP.UPGRADE_METHOD = 'R12_11ICASH_POST'
AND APP.RECEIVABLE_APPLICATION_ID = ACB.RECEIVABLE_APPLICATION_ID UNION SELECT AR_NUM_RAN_PKG.NUM_RANDOM
, PSD.RECEIVABLE_APPLICATION_ID
, 'RA'
, 'REC'
, PSD.MF_CASH_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)
, APP.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')
, 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)
, PSD.MF_CASH_CCID
, 'PSA_MF_RCT_DIST_ALL'
, 'Y'
FROM PSA_MF_RCT_DIST_ALL PSD
, AR_RECEIVABLE_APPLICATIONS_ALL APP
, RA_CUSTOMER_TRX_ALL TRX
, RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD
WHERE APP.UPGRADE_METHOD = 'R12_11IMFAR_POST'
AND APP.RECEIVABLE_APPLICATION_ID = PSD.RECEIVABLE_APPLICATION_ID
AND NVL(PSD.AMOUNT
, 0) <> 0
AND APP.APPLIED_CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND PSD.CUST_TRX_LINE_GL_DIST_ID = CTLGD.CUST_TRX_LINE_GL_DIST_ID UNION SELECT AR_NUM_RAN_PKG.NUM_RANDOM
, PSD.RECEIVABLE_APPLICATION_ID
, 'RA'
, 'EDISC'
, PSD.DISCOUNT_CCID
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, 1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, -1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, 1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, -1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, APP.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')
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, 1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, -1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, 1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, -1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, PSD.DISCOUNT_CCID
, 'PSA_MF_RCT_DIST_ALL'
, 'Y'
FROM PSA_MF_RCT_DIST_ALL PSD
, AR_RECEIVABLE_APPLICATIONS_ALL APP
, RA_CUSTOMER_TRX_ALL TRX
, RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD
WHERE APP.UPGRADE_METHOD = 'R12_11IMFAR_POST'
AND APP.RECEIVABLE_APPLICATION_ID = PSD.RECEIVABLE_APPLICATION_ID
AND NVL(PSD.DISCOUNT_AMOUNT
, 0) <> 0
AND APP.APPLIED_CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND PSD.CUST_TRX_LINE_GL_DIST_ID = CTLGD.CUST_TRX_LINE_GL_DIST_ID UNION SELECT AR_NUM_RAN_PKG.NUM_RANDOM
, PSD.RECEIVABLE_APPLICATION_ID
, 'RA'
, 'UEDISC'
, PSD.UE_DISCOUNT_CCID
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, 1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, -1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, 1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, -1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, APP.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')
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, 1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, -1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, 1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, -1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, PSD.UE_DISCOUNT_CCID
, 'PSA_MF_RCT_DIST_ALL'
, 'Y'
FROM PSA_MF_RCT_DIST_ALL PSD
, AR_RECEIVABLE_APPLICATIONS_ALL APP
, RA_CUSTOMER_TRX_ALL TRX
, RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD
WHERE APP.UPGRADE_METHOD = 'R12_11IMFAR_POST'
AND APP.RECEIVABLE_APPLICATION_ID = PSD.RECEIVABLE_APPLICATION_ID
AND NVL(PSD.UE_DISCOUNT_AMOUNT
, 0) <> 0
AND APP.APPLIED_CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND PSD.CUST_TRX_LINE_GL_DIST_ID = CTLGD.CUST_TRX_LINE_GL_DIST_ID

Columns

Name
LINE_ID
SOURCE_ID
SOURCE_TABLE
SOURCE_TYPE
CODE_COMBINATION_ID
AMOUNT_DR
AMOUNT_CR
ACCTD_AMOUNT_DR
ACCTD_AMOUNT_CR
ORG_ID
SOURCE_TABLE_SECONDARY
SOURCE_ID_SECONDARY
CURRENCY_CODE
CURRENCY_CONVERSION_RATE
CURRENCY_CONVERSION_TYPE
CURRENCY_CONVERSION_DATE
TAXABLE_ENTERED_DR
TAXABLE_ENTERED_CR
TAXABLE_ACCOUNTED_DR
TAXABLE_ACCOUNTED_CR
TAX_LINK_ID
THIRD_PARTY_ID
THIRD_PARTY_SUB_ID
REVERSED_SOURCE_ID
TAX_CODE_ID
LOCATION_SEGMENT_ID
SOURCE_TYPE_SECONDARY
TAX_GROUP_CODE_ID
REF_CUSTOMER_TRX_LINE_ID
REF_CUST_TRX_LINE_GL_DIST_ID
REF_LINE_ID
REF_ACCOUNT_CLASS
ACTIVITY_BUCKET
FROM_AMOUNT_DR
FROM_AMOUNT_CR
FROM_ACCTD_AMOUNT_DR
FROM_ACCTD_AMOUNT_CR
REF_DIST_CCID
ORIGIN_EXTRACT_TABLE
REF_MF_DIST_FLAG