VIEW: AP.AP_CARD_PROGRAMS_ALL#

Source

View Text - Preformatted

select CARD_PROGRAM_NAME CARD_PROGRAM_NAME, CARD_PROGRAM_ID CARD_PROGRAM_ID, CARD_CODE_SET_ID CARD_CODE_SET_ID, CARD_TYPE_LOOKUP_CODE CARD_TYPE_LOOKUP_CODE, CARD_PROGRAM_CURRENCY_CODE CARD_PROGRAM_CURRENCY_CODE, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, EXCLUDE_UNVERIFIED_FLAG EXCLUDE_UNVERIFIED_FLAG, EXCLUDE_PERSONAL_FLAG EXCLUDE_PERSONAL_FLAG, EXCLUDE_DISPUTED_FLAG EXCLUDE_DISPUTED_FLAG, EXCLUDE_REJECTED_FLAG EXCLUDE_REJECTED_FLAG, EXCLUDE_ACCT_EXCEPTION_FLAG EXCLUDE_ACCT_EXCEPTION_FLAG, EXCLUDE_UNRECONCILED_FLAG EXCLUDE_UNRECONCILED_FLAG, EXCLUDE_HELD_FLAG EXCLUDE_HELD_FLAG, EXCEPTION_CLEARING_CCID EXCEPTION_CLEARING_CCID, ADMIN_EMPLOYEE_ID ADMIN_EMPLOYEE_ID, EXPOSURE_LIMIT_AMOUNT EXPOSURE_LIMIT_AMOUNT, DESCRIPTION DESCRIPTION, ORG_ID ORG_ID, INACTIVE_DATE INACTIVE_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CARD_BRAND_LOOKUP_CODE CARD_BRAND_LOOKUP_CODE, AUTO_ITEMIZE_ENABLED_FLAG AUTO_ITEMIZE_ENABLED_FLAG, CARD_EXP_TYPE_SOURCE_COL CARD_EXP_TYPE_SOURCE_COL, CARD_EXP_TYPE_MAP_TYPE_CODE CARD_EXP_TYPE_MAP_TYPE_CODE, COUNTRY_MAP_TYPE_CODE COUNTRY_MAP_TYPE_CODE, CARD_EMP_MATCHING_RULE CARD_EMP_MATCHING_RULE, SYSADMIN_ROLE_NAME SYSADMIN_ROLE_NAME, EXPENSE_CLEARING_CCID EXPENSE_CLEARING_CCID, PAYMENT_DUE_FROM_CODE PAYMENT_DUE_FROM_CODE, DETAIL_WAITING_DURATION DETAIL_WAITING_DURATION, LAST_DOWNLOAD_DATE LAST_DOWNLOAD_DATE, LAST_DOWNLOAD_SIZE LAST_DOWNLOAD_SIZE, AVERAGE_DOWNLOAD_SIZE AVERAGE_DOWNLOAD_SIZE, DOWNLOAD_COUNT DOWNLOAD_COUNT, DATA_FEED_LEVEL_CODE DATA_FEED_LEVEL_CODE, CARD_EXP_TYPE_DETAIL_MAP_CODE CARD_EXP_TYPE_DETAIL_MAP_CODE, GL_PROGRAM_NAME GL_PROGRAM_NAME, COMPANY_NUMBER COMPANY_NUMBER, MARKET_CODE MARKET_CODE from "AP"."AP_CARD_PROGRAMS_ALL"

View Text - HTML Formatted

SELECT CARD_PROGRAM_NAME CARD_PROGRAM_NAME
, CARD_PROGRAM_ID CARD_PROGRAM_ID
, CARD_CODE_SET_ID CARD_CODE_SET_ID
, CARD_TYPE_LOOKUP_CODE CARD_TYPE_LOOKUP_CODE
, CARD_PROGRAM_CURRENCY_CODE CARD_PROGRAM_CURRENCY_CODE
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, EXCLUDE_UNVERIFIED_FLAG EXCLUDE_UNVERIFIED_FLAG
, EXCLUDE_PERSONAL_FLAG EXCLUDE_PERSONAL_FLAG
, EXCLUDE_DISPUTED_FLAG EXCLUDE_DISPUTED_FLAG
, EXCLUDE_REJECTED_FLAG EXCLUDE_REJECTED_FLAG
, EXCLUDE_ACCT_EXCEPTION_FLAG EXCLUDE_ACCT_EXCEPTION_FLAG
, EXCLUDE_UNRECONCILED_FLAG EXCLUDE_UNRECONCILED_FLAG
, EXCLUDE_HELD_FLAG EXCLUDE_HELD_FLAG
, EXCEPTION_CLEARING_CCID EXCEPTION_CLEARING_CCID
, ADMIN_EMPLOYEE_ID ADMIN_EMPLOYEE_ID
, EXPOSURE_LIMIT_AMOUNT EXPOSURE_LIMIT_AMOUNT
, DESCRIPTION DESCRIPTION
, ORG_ID ORG_ID
, INACTIVE_DATE INACTIVE_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CARD_BRAND_LOOKUP_CODE CARD_BRAND_LOOKUP_CODE
, AUTO_ITEMIZE_ENABLED_FLAG AUTO_ITEMIZE_ENABLED_FLAG
, CARD_EXP_TYPE_SOURCE_COL CARD_EXP_TYPE_SOURCE_COL
, CARD_EXP_TYPE_MAP_TYPE_CODE CARD_EXP_TYPE_MAP_TYPE_CODE
, COUNTRY_MAP_TYPE_CODE COUNTRY_MAP_TYPE_CODE
, CARD_EMP_MATCHING_RULE CARD_EMP_MATCHING_RULE
, SYSADMIN_ROLE_NAME SYSADMIN_ROLE_NAME
, EXPENSE_CLEARING_CCID EXPENSE_CLEARING_CCID
, PAYMENT_DUE_FROM_CODE PAYMENT_DUE_FROM_CODE
, DETAIL_WAITING_DURATION DETAIL_WAITING_DURATION
, LAST_DOWNLOAD_DATE LAST_DOWNLOAD_DATE
, LAST_DOWNLOAD_SIZE LAST_DOWNLOAD_SIZE
, AVERAGE_DOWNLOAD_SIZE AVERAGE_DOWNLOAD_SIZE
, DOWNLOAD_COUNT DOWNLOAD_COUNT
, DATA_FEED_LEVEL_CODE DATA_FEED_LEVEL_CODE
, CARD_EXP_TYPE_DETAIL_MAP_CODE CARD_EXP_TYPE_DETAIL_MAP_CODE
, GL_PROGRAM_NAME GL_PROGRAM_NAME
, COMPANY_NUMBER COMPANY_NUMBER
, MARKET_CODE MARKET_CODE
FROM "AP"."AP_CARD_PROGRAMS_ALL"