VIEW: IGI.IGI_EXP_TRAN_UNIT_DEF_ALL#

Source

View Text - Preformatted

select TRANS_UNIT_ID TRANS_UNIT_ID, TRANS_UNIT_NUM TRANS_UNIT_NUM, DOC_TYPE_ID DOC_TYPE_ID, ACT_NUMBER ACT_NUMBER, TRANS_UNIT_STATUS TRANS_UNIT_STATUS, TRANS_UNIT_NUM_TYPE TRANS_UNIT_NUM_TYPE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, ORG_ID ORG_ID, LEGAL_NUMBER LEGAL_NUMBER, MRC_EXCHANGE_RATE_TYPE MRC_EXCHANGE_RATE_TYPE, THIRD_PARTY_ID THIRD_PARTY_ID, TRAN_UNIT_CALL_NUM TRAN_UNIT_CALL_NUM, AMOUNT AMOUNT, MRC_AMOUNT MRC_AMOUNT, MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE, MRC_EXCHANGE_DATE MRC_EXCHANGE_DATE, MRC_AMOUNT_EXCHANGE_RATE_TYPE MRC_AMOUNT_EXCHANGE_RATE_TYPE, PRINT_DATE PRINT_DATE, IEL_TRANS_UNIT_ID IEL_TRANS_UNIT_ID, UPGRADE_STATUS UPGRADE_STATUS from "IGI"."IGI_EXP_TRAN_UNIT_DEF_ALL"

View Text - HTML Formatted

SELECT TRANS_UNIT_ID TRANS_UNIT_ID
, TRANS_UNIT_NUM TRANS_UNIT_NUM
, DOC_TYPE_ID DOC_TYPE_ID
, ACT_NUMBER ACT_NUMBER
, TRANS_UNIT_STATUS TRANS_UNIT_STATUS
, TRANS_UNIT_NUM_TYPE TRANS_UNIT_NUM_TYPE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, ORG_ID ORG_ID
, LEGAL_NUMBER LEGAL_NUMBER
, MRC_EXCHANGE_RATE_TYPE MRC_EXCHANGE_RATE_TYPE
, THIRD_PARTY_ID THIRD_PARTY_ID
, TRAN_UNIT_CALL_NUM TRAN_UNIT_CALL_NUM
, AMOUNT AMOUNT
, MRC_AMOUNT MRC_AMOUNT
, MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE
, MRC_EXCHANGE_DATE MRC_EXCHANGE_DATE
, MRC_AMOUNT_EXCHANGE_RATE_TYPE MRC_AMOUNT_EXCHANGE_RATE_TYPE
, PRINT_DATE PRINT_DATE
, IEL_TRANS_UNIT_ID IEL_TRANS_UNIT_ID
, UPGRADE_STATUS UPGRADE_STATUS
FROM "IGI"."IGI_EXP_TRAN_UNIT_DEF_ALL"