VIEW: IGI.IGI_STP_CANDIDATES_ALL#

Source

View Text - Preformatted

select USER_ID USER_ID, STP_ID STP_ID, SITE_ID SITE_ID, BATCH_ID BATCH_ID, APPLICATION APPLICATION, TRX_ID TRX_ID, TRX_NUMBER TRX_NUMBER, AMOUNT AMOUNT, PROCESS_FLAG PROCESS_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORG_ID ORG_ID, PACKAGE_ID PACKAGE_ID, NETTING_TRX_TYPE_ID NETTING_TRX_TYPE_ID, REFERENCE REFERENCE, ACCOUNTING_DATE ACCOUNTING_DATE, NETTING_AMOUNT NETTING_AMOUNT, DIAL_UNIT_ID DIAL_UNIT_ID, PACKAGE_NUM PACKAGE_NUM, CURRENCY_CODE CURRENCY_CODE, CONTRA_PARTY_ID CONTRA_PARTY_ID, CONTRA_SITE_ID CONTRA_SITE_ID, CONTRA_AMOUNT CONTRA_AMOUNT, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_DATE EXCHANGE_DATE, TRX_TYPE TRX_TYPE from "IGI"."IGI_STP_CANDIDATES_ALL"

View Text - HTML Formatted

SELECT USER_ID USER_ID
, STP_ID STP_ID
, SITE_ID SITE_ID
, BATCH_ID BATCH_ID
, APPLICATION APPLICATION
, TRX_ID TRX_ID
, TRX_NUMBER TRX_NUMBER
, AMOUNT AMOUNT
, PROCESS_FLAG PROCESS_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORG_ID ORG_ID
, PACKAGE_ID PACKAGE_ID
, NETTING_TRX_TYPE_ID NETTING_TRX_TYPE_ID
, REFERENCE REFERENCE
, ACCOUNTING_DATE ACCOUNTING_DATE
, NETTING_AMOUNT NETTING_AMOUNT
, DIAL_UNIT_ID DIAL_UNIT_ID
, PACKAGE_NUM PACKAGE_NUM
, CURRENCY_CODE CURRENCY_CODE
, CONTRA_PARTY_ID CONTRA_PARTY_ID
, CONTRA_SITE_ID CONTRA_SITE_ID
, CONTRA_AMOUNT CONTRA_AMOUNT
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_DATE EXCHANGE_DATE
, TRX_TYPE TRX_TYPE
FROM "IGI"."IGI_STP_CANDIDATES_ALL"