Product: | FII - Financial Intelligence |
---|---|
Description: | FIIBV_AR_ARTT_TYPE_LCV is the base view for AR Transaction type level of AR Transaction Type dimension |
Implementation/DBA Data: | APPS.FIIBV_AR_ARTT_TYPE_LCV |
SELECT CTT.CUST_TRX_TYPE_ID||'-'||ORG_ID||'-'||SUBSTR(EDW_INSTANCE.GET_CODE
, 1
, 40)
, CTT.TYPE
, CTT.NAME
, CTT.NAME
, CTT.NAME
, CTT.ALLOW_FREIGHT_FLAG
, CTT.ALLOW_OVERAPPLICATION_FLAG
, CTT.CREATION_SIGN
, CTT.DEFAULT_STATUS
, CTT.DESCRIPTION
, CTT.STATUS
, CTT.TAX_CALCULATION_FLAG
, CTT.CREDIT_MEMO_TYPE_ID
, CTT.DEFAULT_TERM
, CTT.END_DATE
, CTT.GL_ID_CLEARING
, CTT.GL_ID_FREIGHT
, CTT.GL_ID_REC
, CTT.GL_ID_REV
, CTT.GL_ID_TAX
, CTT.GL_ID_UNBILLED
, CTT.GL_ID_UNEARNED
, CTT.ORG_ID
, CTT.RULE_SET_ID
, CTT.SET_OF_BOOKS_ID
, CTT.START_DATE
, CTT.SUBSEQUENT_TRX_TYPE_ID
, SUBSTR(EDW_INSTANCE.GET_CODE
, 1
, 40)
, CTT.LAST_UPDATE_DATE
, '_DF:AR:RA_CUST_TRX_TYPES:CTT'
, '_DF:JG:JG_RA_CUST_TRX_TYPES:CTT'
FROM RA_CUST_TRX_TYPES_ALL CTT