eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: IGI.IGI_EXP_DIAL_UNIT_DEF_ALL#

Source

View Text - Preformatted


select DIAL_UNIT_ID DIAL_UNIT_ID, DIAL_UNIT_NUM DIAL_UNIT_NUM, TRX_TYPE_ID TRX_TYPE_ID, DOC_TYPE_ID DOC_TYPE_ID, THIRD_PARTY_ID THIRD_PARTY_ID, DIAL_UNIT_NUM_TYPE DIAL_UNIT_NUM_TYPE, ACT_NUMBER ACT_NUMBER, STATUS STATUS, 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, CURRENCY_CODE CURRENCY_CODE, SITE_ID SITE_ID, MRC_EXCHANGE_RATE_TYPE MRC_EXCHANGE_RATE_TYPE, MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE, MRC_EXCHANGE_DATE MRC_EXCHANGE_DATE, LEGAL_NUMBER LEGAL_NUMBER, AMOUNT AMOUNT, MRC_AMOUNT MRC_AMOUNT, MRC_AMOUNT_EXCHANGE_RATE_TYPE MRC_AMOUNT_EXCHANGE_RATE_TYPE, MRC_AMOUNT_EXCHANGE_DATE MRC_AMOUNT_EXCHANGE_DATE, MRC_AMOUNT_EXCHANGE_RATE MRC_AMOUNT_EXCHANGE_RATE, DESCRIPTION DESCRIPTION, TRANS_UNIT_ID TRANS_UNIT_ID, DIAL_UNIT_SELECTED_FLAG DIAL_UNIT_SELECTED_FLAG, DIAL_UNIT_CALL_NUM DIAL_UNIT_CALL_NUM, MAIN_AUTHORIZER MAIN_AUTHORIZER, ACCOUNT_OFFICER ACCOUNT_OFFICER, PRINT_DATE PRINT_DATE, REQ_REJECT REQ_REJECT, UPGRADE_STATUS UPGRADE_STATUS from "IGI"."IGI_EXP_DIAL_UNIT_DEF_ALL"

View Text - HTML Formatted

SELECT DIAL_UNIT_ID DIAL_UNIT_ID
, DIAL_UNIT_NUM DIAL_UNIT_NUM
, TRX_TYPE_ID TRX_TYPE_ID
, DOC_TYPE_ID DOC_TYPE_ID
, THIRD_PARTY_ID THIRD_PARTY_ID
, DIAL_UNIT_NUM_TYPE DIAL_UNIT_NUM_TYPE
, ACT_NUMBER ACT_NUMBER
, STATUS STATUS
, 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
, CURRENCY_CODE CURRENCY_CODE
, SITE_ID SITE_ID
, MRC_EXCHANGE_RATE_TYPE MRC_EXCHANGE_RATE_TYPE
, MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE
, MRC_EXCHANGE_DATE MRC_EXCHANGE_DATE
, LEGAL_NUMBER LEGAL_NUMBER
, AMOUNT AMOUNT
, MRC_AMOUNT MRC_AMOUNT
, MRC_AMOUNT_EXCHANGE_RATE_TYPE MRC_AMOUNT_EXCHANGE_RATE_TYPE
, MRC_AMOUNT_EXCHANGE_DATE MRC_AMOUNT_EXCHANGE_DATE
, MRC_AMOUNT_EXCHANGE_RATE MRC_AMOUNT_EXCHANGE_RATE
, DESCRIPTION DESCRIPTION
, TRANS_UNIT_ID TRANS_UNIT_ID
, DIAL_UNIT_SELECTED_FLAG DIAL_UNIT_SELECTED_FLAG
, DIAL_UNIT_CALL_NUM DIAL_UNIT_CALL_NUM
, MAIN_AUTHORIZER MAIN_AUTHORIZER
, ACCOUNT_OFFICER ACCOUNT_OFFICER
, PRINT_DATE PRINT_DATE
, REQ_REJECT REQ_REJECT
, UPGRADE_STATUS UPGRADE_STATUS
FROM "IGI"."IGI_EXP_DIAL_UNIT_DEF_ALL"