VIEW: APPS.FIIBV_AR_ARTT_TYPE_LCV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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