View: RA_CUST_TRX_LINE_GL_DIST_V

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

View Text

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(+)

Columns