View: AR_CORRECT_GL_LINES_V

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

View Text

SELECT ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING( DECODE(ACC.DISTRIBUTION_TYPE
, 'REC'
, 'DISTRIBUTION_SOURCE_TYPE'
, 'AUTOGL_TYPE')
, ACC.DISTRIBUTION_TYPE)
, ACC.DISTRIBUTION_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('INV/CM/ADJ'
, ACC.CATEGORY_TYPE)
, ACC.CATEGORY_TYPE
, ACC.DISTRIBUTION_ID
, ACC.PARENT_ID
, ACC.SOURCE_TABLE
, ACC.CODE_COMBINATION_ID
, TRX.TRX_NUMBER
, TTYPE.NAME
, ACC.GL_DATE
, SRC.NAME
, SREP.NAME
, PARTY.PARTY_NAME
, NULL
, DECODE(IBY.INSTRUMENT_TYPE
, 'BANKACCOUNT'
, IBY.ACCOUNT_NUMBER
, 'CREDITCARD'
, IBY.CARD_NUMBER
, NULL)
FROM AR_CCID_CORRECTIONS ACC
, RA_CUSTOMER_TRX TRX
, RA_CUST_TRX_LINE_GL_DIST GLD
, RA_CUST_TRX_TYPES TTYPE
, RA_BATCH_SOURCES SRC
, IBY_TRXN_EXTENSIONS_V IBY
, RA_CUST_TRX_LINE_SALESREPS SR
, RA_SALESREPS SREP
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST
WHERE ACC.PARENT_ID = TRX.CUSTOMER_TRX_ID
AND ACC.SOURCE_TABLE = 'GLD'
AND ACC.DISTRIBUTION_ID = GLD.CUST_TRX_LINE_GL_DIST_ID
AND TRX.CUST_TRX_TYPE_ID = TTYPE.CUST_TRX_TYPE_ID
AND SRC.BATCH_SOURCE_ID (+) = TRX.BATCH_SOURCE_ID
AND TRX.PAYMENT_TRXN_EXTENSION_ID = IBY.TRXN_EXTENSION_ID(+)
AND GLD.CUST_TRX_LINE_SALESREP_ID = SR.CUST_TRX_LINE_SALESREP_ID (+)
AND NVL(NVL(SR.SALESREP_ID
, TRX.PRIMARY_SALESREP_ID)
, -3) = SREP.SALESREP_ID
AND CUST.CUST_ACCOUNT_ID = TRX.BILL_TO_CUSTOMER_ID
AND CUST.PARTY_ID = PARTY.PARTY_ID UNION ALL SELECT ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING( 'DISTRIBUTION_SOURCE_TYPE'
, ACC.DISTRIBUTION_TYPE)
, ACC.DISTRIBUTION_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('ARRGTA_CATEGORIES'
, ACC.CATEGORY_TYPE)
, ACC.CATEGORY_TYPE
, ACC.DISTRIBUTION_ID
, ACC.PARENT_ID
, ACC.SOURCE_TABLE
, ACC.CODE_COMBINATION_ID
, ADJ.ADJUSTMENT_NUMBER
, ADJ.REASON_CODE
, ACC.GL_DATE
, NULL
, NULL
, PARTY.PARTY_NAME
, NULL
, NULL
FROM AR_CCID_CORRECTIONS ACC
, AR_ADJUSTMENTS ADJ
, RA_CUSTOMER_TRX TRX
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST
WHERE ACC.SOURCE_TABLE = 'ADJ'
AND ACC.PARENT_ID = ADJ.ADJUSTMENT_ID
AND ADJ.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND CUST.CUST_ACCOUNT_ID = TRX.BILL_TO_CUSTOMER_ID
AND CUST.PARTY_ID = PARTY.PARTY_ID UNION ALL SELECT ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('DISTRIBUTION_SOURCE_TYPE'
, ACC.DISTRIBUTION_TYPE)
, ACC.DISTRIBUTION_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('ARRGTA_CATEGORIES'
, ACC.CATEGORY_TYPE)
, ACC.CATEGORY_TYPE
, ACC.DISTRIBUTION_ID
, ACC.PARENT_ID
, ACC.SOURCE_TABLE
, ACC.CODE_COMBINATION_ID
, CR.RECEIPT_NUMBER
, NULL
, ACC.GL_DATE
, NULL
, NULL
, PARTY.PARTY_NAME
, NULL
, DECODE(IBY.INSTRUMENT_TYPE
, 'BANKACCOUNT'
, IBY.ACCOUNT_NUMBER
, 'CREDITCARD'
, IBY.CARD_NUMBER
, NULL)
FROM AR_CCID_CORRECTIONS ACC
, AR_CASH_RECEIPT_HISTORY CRH
, AR_CASH_RECEIPTS CR
, IBY_TRXN_EXTENSIONS_V IBY
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST
WHERE ACC.SOURCE_TABLE = 'CRH'
AND ACC.PARENT_ID = CRH.CASH_RECEIPT_HISTORY_ID
AND CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
AND CUST.CUST_ACCOUNT_ID (+) = CR.PAY_FROM_CUSTOMER
AND CUST.PARTY_ID = PARTY.PARTY_ID (+)
AND CR.PAYMENT_TRXN_EXTENSION_ID = IBY.TRXN_EXTENSION_ID(+) UNION ALL SELECT ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING( 'DISTRIBUTION_SOURCE_TYPE'
, ACC.DISTRIBUTION_TYPE)
, ACC.DISTRIBUTION_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('ARRGTA_CATEGORIES'
, ACC.CATEGORY_TYPE)
, ACC.CATEGORY_TYPE
, ACC.DISTRIBUTION_ID
, ACC.PARENT_ID
, ACC.SOURCE_TABLE
, ACC.CODE_COMBINATION_ID
, CR.RECEIPT_NUMBER
, NULL
, ACC.GL_DATE
, NULL
, NULL
, PARTY.PARTY_NAME
, NULL
, DECODE(IBY.INSTRUMENT_TYPE
, 'BANKACCOUNT'
, IBY.ACCOUNT_NUMBER
, 'CREDITCARD'
, IBY.CARD_NUMBER
, NULL)
FROM AR_CCID_CORRECTIONS ACC
, AR_RECEIVABLE_APPLICATIONS RA
, AR_CASH_RECEIPTS CR
, IBY_TRXN_EXTENSIONS_V IBY
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST
WHERE ACC.SOURCE_TABLE = 'RA'
AND ACC.PARENT_ID = RA.RECEIVABLE_APPLICATION_ID
AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
AND CUST.CUST_ACCOUNT_ID (+) = CR.PAY_FROM_CUSTOMER
AND CUST.PARTY_ID = PARTY.PARTY_ID (+)
AND CR.PAYMENT_TRXN_EXTENSION_ID = IBY.TRXN_EXTENSION_ID(+) UNION ALL SELECT ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING( 'DISTRIBUTION_SOURCE_TYPE'
, ACC.DISTRIBUTION_TYPE)
, ACC.DISTRIBUTION_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('ARRGTA_CATEGORIES'
, ACC.CATEGORY_TYPE)
, ACC.CATEGORY_TYPE
, ACC.DISTRIBUTION_ID
, ACC.PARENT_ID
, ACC.SOURCE_TABLE
, ACC.CODE_COMBINATION_ID
, CM.TRX_NUMBER
, TTYPE.NAME
, ACC.GL_DATE
, NULL
, NULL
, PARTY.PARTY_NAME
, NULL
, DECODE(IBY.INSTRUMENT_TYPE
, 'BANKACCOUNT'
, IBY.ACCOUNT_NUMBER
, 'CREDITCARD'
, IBY.CARD_NUMBER
, NULL)
FROM AR_CCID_CORRECTIONS ACC
, RA_CUSTOMER_TRX CM
, RA_CUST_TRX_TYPES TTYPE
, AR_RECEIVABLE_APPLICATIONS RA
, IBY_TRXN_EXTENSIONS_V IBY
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST
WHERE ACC.SOURCE_TABLE = 'RA'
AND ACC.PARENT_ID = RA.RECEIVABLE_APPLICATION_ID
AND RA.CUSTOMER_TRX_ID = CM.CUSTOMER_TRX_ID
AND CM.CUST_TRX_TYPE_ID = TTYPE.CUST_TRX_TYPE_ID
AND CUST.CUST_ACCOUNT_ID = CM.BILL_TO_CUSTOMER_ID
AND CUST.PARTY_ID = PARTY.PARTY_ID
AND CM.PAYMENT_TRXN_EXTENSION_ID = IBY.TRXN_EXTENSION_ID(+) UNION ALL SELECT ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('DISTRIBUTION_SOURCE_TYPE'
, ACC.DISTRIBUTION_TYPE)
, ACC.DISTRIBUTION_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('ARRGTA_CATEGORIES'
, ACC.CATEGORY_TYPE)
, ACC.CATEGORY_TYPE
, ACC.DISTRIBUTION_ID
, ACC.PARENT_ID
, ACC.SOURCE_TABLE
, ACC.CODE_COMBINATION_ID
, CR.RECEIPT_NUMBER
, NULL
, ACC.GL_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM AR_CCID_CORRECTIONS ACC
, AR_MISC_CASH_DISTRIBUTIONS MCD
, AR_CASH_RECEIPTS CR
WHERE ACC.SOURCE_TABLE = 'MCD'
AND ACC.PARENT_ID = MCD.MISC_CASH_DISTRIBUTION_ID
AND MCD.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID UNION ALL SELECT ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING( 'DISTRIBUTION_SOURCE_TYPE'
, ACC.DISTRIBUTION_TYPE)
, ACC.DISTRIBUTION_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('ARRGTA_CATEGORIES'
, ACC.CATEGORY_TYPE)
, ACC.CATEGORY_TYPE
, ACC.DISTRIBUTION_ID
, ACC.PARENT_ID
, ACC.SOURCE_TABLE
, ACC.CODE_COMBINATION_ID
, TRX.TRX_NUMBER
, TTYPE.NAME
, ACC.GL_DATE
, NULL
, NULL
, PARTY.PARTY_NAME
, NULL
, DECODE(IBY.INSTRUMENT_TYPE
, 'BANKACCOUNT'
, IBY.ACCOUNT_NUMBER
, 'CREDITCARD'
, IBY.CARD_NUMBER
, NULL)
FROM AR_CCID_CORRECTIONS ACC
, AR_TRANSACTION_HISTORY TH
, RA_CUSTOMER_TRX TRX
, RA_CUST_TRX_TYPES TTYPE
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST
, IBY_TRXN_EXTENSIONS_V IBY
WHERE ACC.SOURCE_TABLE = 'TH'
AND ACC.PARENT_ID = TH.TRANSACTION_HISTORY_ID
AND TH.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND TRX.CUST_TRX_TYPE_ID = TTYPE.CUST_TRX_TYPE_ID
AND CUST.CUST_ACCOUNT_ID = TRX.DRAWEE_ID
AND CUST.PARTY_ID = PARTY.PARTY_ID
AND TRX.PAYMENT_TRXN_EXTENSION_ID = IBY.TRXN_EXTENSION_ID(+)

Columns