VIEW: APPS.RA_CUST_TRX_LINE_GL_DIST_RA_V

Source

View Text - Preformatted

SELECT /* $Header: artrx.odf 120.231.12020000.2 2012/07/27 18:29:53 dgaurab 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(+)

View Text - HTML Formatted

SELECT /* $HEADER: ARTRX.ODF 120.231.12020000.2 2012/07/27 18:29:53 DGAURAB 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(+)