VIEW: APPS.RA_CUST_TRX_LINE_GL_DIST_V

Source

View Text - Preformatted

SELECT 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) , AL_CLASS.MEANING , AL_TYPE.MEANING , LGD.REC_OFFSET_FLAG , LGD.USER_GENERATED_FLAG , LGD.ROUNDING_CORRECTION_FLAG ,LGD.CCID_CHANGE_FLAG , LGD.GLOBAL_ATTRIBUTE_CATEGORY , LGD.GLOBAL_ATTRIBUTE1 , LGD.GLOBAL_ATTRIBUTE2 , LGD.GLOBAL_ATTRIBUTE3 , LGD.GLOBAL_ATTRIBUTE4 , LGD.GLOBAL_ATTRIBUTE5 , LGD.GLOBAL_ATTRIBUTE6 , LGD.GLOBAL_ATTRIBUTE7 , LGD.GLOBAL_ATTRIBUTE8 , LGD.GLOBAL_ATTRIBUTE9 , LGD.GLOBAL_ATTRIBUTE10 , LGD.GLOBAL_ATTRIBUTE11 , LGD.GLOBAL_ATTRIBUTE12 , LGD.GLOBAL_ATTRIBUTE13 , LGD.GLOBAL_ATTRIBUTE14 , LGD.GLOBAL_ATTRIBUTE15 , LGD.GLOBAL_ATTRIBUTE16 , LGD.GLOBAL_ATTRIBUTE17 , LGD.GLOBAL_ATTRIBUTE18 , LGD.GLOBAL_ATTRIBUTE19 , LGD.GLOBAL_ATTRIBUTE20 , LGD.GLOBAL_ATTRIBUTE21 , LGD.GLOBAL_ATTRIBUTE22 , LGD.GLOBAL_ATTRIBUTE23 , LGD.GLOBAL_ATTRIBUTE24 , LGD.GLOBAL_ATTRIBUTE25 , LGD.GLOBAL_ATTRIBUTE26 , LGD.GLOBAL_ATTRIBUTE27 , LGD.GLOBAL_ATTRIBUTE28 , LGD.GLOBAL_ATTRIBUTE29 , LGD.GLOBAL_ATTRIBUTE30 FROM RA_CUST_TRX_LINE_GL_DIST LGD, RA_CUSTOMER_TRX_LINES CTL, RA_CUSTOMER_TRX_LINES CTL_LINE, AR_LOOKUPS AL_CLASS, AR_LOOKUPS AL_TYPE, RA_RULES RR WHERE LGD.CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID(+) AND CTL.LINK_TO_CUST_TRX_LINE_ID = CTL_LINE.CUSTOMER_TRX_LINE_ID(+) AND AL_CLASS.LOOKUP_TYPE = 'AUTOGL_TYPE' AND AL_CLASS.LOOKUP_CODE = LGD.ACCOUNT_CLASS AND AL_TYPE.LOOKUP_TYPE(+) = 'STD_LINE_TYPE' AND AL_TYPE.LOOKUP_CODE(+) = CTL.LINE_TYPE AND CTL.ACCOUNTING_RULE_ID = RR.RULE_ID(+)

View Text - HTML Formatted

SELECT 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)
, AL_CLASS.MEANING
, AL_TYPE.MEANING
, LGD.REC_OFFSET_FLAG
, LGD.USER_GENERATED_FLAG
, LGD.ROUNDING_CORRECTION_FLAG
, LGD.CCID_CHANGE_FLAG
, LGD.GLOBAL_ATTRIBUTE_CATEGORY
, LGD.GLOBAL_ATTRIBUTE1
, LGD.GLOBAL_ATTRIBUTE2
, LGD.GLOBAL_ATTRIBUTE3
, LGD.GLOBAL_ATTRIBUTE4
, LGD.GLOBAL_ATTRIBUTE5
, LGD.GLOBAL_ATTRIBUTE6
, LGD.GLOBAL_ATTRIBUTE7
, LGD.GLOBAL_ATTRIBUTE8
, LGD.GLOBAL_ATTRIBUTE9
, LGD.GLOBAL_ATTRIBUTE10
, LGD.GLOBAL_ATTRIBUTE11
, LGD.GLOBAL_ATTRIBUTE12
, LGD.GLOBAL_ATTRIBUTE13
, LGD.GLOBAL_ATTRIBUTE14
, LGD.GLOBAL_ATTRIBUTE15
, LGD.GLOBAL_ATTRIBUTE16
, LGD.GLOBAL_ATTRIBUTE17
, LGD.GLOBAL_ATTRIBUTE18
, LGD.GLOBAL_ATTRIBUTE19
, LGD.GLOBAL_ATTRIBUTE20
, LGD.GLOBAL_ATTRIBUTE21
, LGD.GLOBAL_ATTRIBUTE22
, LGD.GLOBAL_ATTRIBUTE23
, LGD.GLOBAL_ATTRIBUTE24
, LGD.GLOBAL_ATTRIBUTE25
, LGD.GLOBAL_ATTRIBUTE26
, LGD.GLOBAL_ATTRIBUTE27
, LGD.GLOBAL_ATTRIBUTE28
, LGD.GLOBAL_ATTRIBUTE29
, LGD.GLOBAL_ATTRIBUTE30
FROM RA_CUST_TRX_LINE_GL_DIST LGD
, RA_CUSTOMER_TRX_LINES CTL
, RA_CUSTOMER_TRX_LINES CTL_LINE
, AR_LOOKUPS AL_CLASS
, AR_LOOKUPS AL_TYPE
, RA_RULES RR
WHERE LGD.CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID(+)
AND CTL.LINK_TO_CUST_TRX_LINE_ID = CTL_LINE.CUSTOMER_TRX_LINE_ID(+)
AND AL_CLASS.LOOKUP_TYPE = 'AUTOGL_TYPE'
AND AL_CLASS.LOOKUP_CODE = LGD.ACCOUNT_CLASS
AND AL_TYPE.LOOKUP_TYPE(+) = 'STD_LINE_TYPE'
AND AL_TYPE.LOOKUP_CODE(+) = CTL.LINE_TYPE
AND CTL.ACCOUNTING_RULE_ID = RR.RULE_ID(+)