VIEW: IGI.IGI_STP_PACKAGES_ALL#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, PACKAGE_ID PACKAGE_ID, STP_ID STP_ID, SITE_ID SITE_ID, APPLICATION APPLICATION, AMOUNT AMOUNT, ACCOUNTING_DATE ACCOUNTING_DATE, 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, MRC_AMOUNT MRC_AMOUNT, MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE, MRC_EXCHANGE_RATE_TYPE MRC_EXCHANGE_RATE_TYPE, MRC_EXCHANGE_DATE MRC_EXCHANGE_DATE, MRC_EXCHANGE_STATUS MRC_EXCHANGE_STATUS, TRX_NUMBER TRX_NUMBER, REFERENCE REFERENCE, NETTING_TRX_TYPE_ID NETTING_TRX_TYPE_ID, ACCT_PAY_CODE_COMBINATION_ID ACCT_PAY_CODE_COMBINATION_ID, REC_CODE_COMBINATION_ID REC_CODE_COMBINATION_ID, TRX_TYPE_CLASS TRX_TYPE_CLASS, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE, DESCRIPTION DESCRIPTION, DOC_CATEGORY_CODE DOC_CATEGORY_CODE, RELATED_TRX_NUMBER RELATED_TRX_NUMBER, PACKAGE_NUM PACKAGE_NUM, TECHNICAL_CCID TECHNICAL_CCID, REC_OR_LIAB_CCID REC_OR_LIAB_CCID, CURRENCY_CODE CURRENCY_CODE, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_DATE EXCHANGE_DATE, IGI_STP_PACKAGES_ALL_BATCH_ID IGI_STP_PACKAGES_ALL_BATCH_ID from "IGI"."IGI_STP_PACKAGES_ALL"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, PACKAGE_ID PACKAGE_ID
, STP_ID STP_ID
, SITE_ID SITE_ID
, APPLICATION APPLICATION
, AMOUNT AMOUNT
, ACCOUNTING_DATE ACCOUNTING_DATE
, 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
, MRC_AMOUNT MRC_AMOUNT
, MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE
, MRC_EXCHANGE_RATE_TYPE MRC_EXCHANGE_RATE_TYPE
, MRC_EXCHANGE_DATE MRC_EXCHANGE_DATE
, MRC_EXCHANGE_STATUS MRC_EXCHANGE_STATUS
, TRX_NUMBER TRX_NUMBER
, REFERENCE REFERENCE
, NETTING_TRX_TYPE_ID NETTING_TRX_TYPE_ID
, ACCT_PAY_CODE_COMBINATION_ID ACCT_PAY_CODE_COMBINATION_ID
, REC_CODE_COMBINATION_ID REC_CODE_COMBINATION_ID
, TRX_TYPE_CLASS TRX_TYPE_CLASS
, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE
, DESCRIPTION DESCRIPTION
, DOC_CATEGORY_CODE DOC_CATEGORY_CODE
, RELATED_TRX_NUMBER RELATED_TRX_NUMBER
, PACKAGE_NUM PACKAGE_NUM
, TECHNICAL_CCID TECHNICAL_CCID
, REC_OR_LIAB_CCID REC_OR_LIAB_CCID
, CURRENCY_CODE CURRENCY_CODE
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_DATE EXCHANGE_DATE
, IGI_STP_PACKAGES_ALL_BATCH_ID IGI_STP_PACKAGES_ALL_BATCH_ID
FROM "IGI"."IGI_STP_PACKAGES_ALL"