View: RA_CUST_TRX_LINE_GL_DIST_RA_V

Product:	AR - Receivables
Description:	(Release 115)
Implementation/DBA Data:	APPS.RA_CUST_TRX_LINE_GL_DIST_RA_V

View Text

SELECT /* $HEADER: ARTRXREG.LDT 120.87.12010000.18 2009/01/27 14:34:46 ANKUAGAR SHIP $ */ LGD.ROWID
, LGD.CUST_TRX_LINE_GL_DIST_ID
, LGD.CUSTOMER_TRX_ID
, LGD.CUSTOMER_TRX_LINE_ID
, LGD.CUST_TRX_LINE_SALESREP_ID
, LGD.PERCENT
, LGD.AMOUNT
, LGD.ACCTD_AMOUNT
, LGD.GL_DATE
, LGD.ORIGINAL_GL_DATE
, LGD.GL_POSTED_DATE
, LGD.ACCOUNT_CLASS
, LGD.ACCOUNT_SET_FLAG
, LGD.LATEST_REC_FLAG
, LGD.CODE_COMBINATION_ID
, LGD.CONCATENATED_SEGMENTS
, LGD.COLLECTED_TAX_CCID
, LGD.COLLECTED_TAX_CONCAT_SEG
, LGD.COMMENTS
, LGD.SET_OF_BOOKS_ID
, LGD.LAST_UPDATE_DATE
, LGD.LAST_UPDATED_BY
, LGD.CREATION_DATE
, LGD.CREATED_BY
, LGD.LAST_UPDATE_LOGIN
, LGD.REQUEST_ID
, LGD.PROGRAM_APPLICATION_ID
, LGD.PROGRAM_ID
, LGD.PROGRAM_UPDATE_DATE
, LGD.POST_REQUEST_ID
, LGD.POSTING_CONTROL_ID
, LGD.RA_POST_LOOP_NUMBER
, LGD.USSGL_TRANSACTION_CODE
, LGD.USSGL_TRANSACTION_CODE_CONTEXT
, LGD.ATTRIBUTE_CATEGORY
, LGD.ATTRIBUTE1
, LGD.ATTRIBUTE2
, LGD.ATTRIBUTE3
, LGD.ATTRIBUTE4
, LGD.ATTRIBUTE5
, LGD.ATTRIBUTE6
, LGD.ATTRIBUTE7
, LGD.ATTRIBUTE8
, LGD.ATTRIBUTE9
, LGD.ATTRIBUTE10
, LGD.ATTRIBUTE11
, LGD.ATTRIBUTE12
, LGD.ATTRIBUTE13
, LGD.ATTRIBUTE14
, LGD.ATTRIBUTE15
, CTL.EXTENDED_AMOUNT
, RR.NAME
, DECODE(CTL.LINK_TO_CUST_TRX_LINE_ID
, NULL
, CTL.LINE_NUMBER
, CTL_LINE.LINE_NUMBER)
, DECODE(CTL.LINK_TO_CUST_TRX_LINE_ID
, NULL
, ''
, CTL.LINE_NUMBER)
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('AUTOGL_TYPE'
, LGD.ACCOUNT_CLASS) AL_CLASS_MEANING
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('STD_LINE_TYPE'
, CTL.LINE_TYPE) AL_LINE_TYPE_MEANING
, LGD.REVENUE_ADJUSTMENT_ID
, RA.REVENUE_ADJUSTMENT_NUMBER RA_REVENUE_ADJUSTMENT_NUMBER
, LGD.REC_OFFSET_FLAG
, LGD.USER_GENERATED_FLAG
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO'
, LGD.USER_GENERATED_FLAG) USER_GENERATED_FLAG_MEANING
FROM RA_CUST_TRX_LINE_GL_DIST LGD
, RA_CUSTOMER_TRX_LINES CTL
, RA_CUSTOMER_TRX_LINES CTL_LINE
, AR_REVENUE_ADJUSTMENTS RA
, RA_RULES RR
WHERE LGD.CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID(+)
AND LGD.REVENUE_ADJUSTMENT_ID = RA.REVENUE_ADJUSTMENT_ID(+)
AND CTL.LINK_TO_CUST_TRX_LINE_ID = CTL_LINE.CUSTOMER_TRX_LINE_ID(+)
AND CTL.ACCOUNTING_RULE_ID = RR.RULE_ID(+)

Columns