Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: AP.AP_CARD_PROGRAMS_ALL#

Object Details
Object Name: AP_CARD_PROGRAMS_ALL#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CARD_PROGRAM_NAME VARCHAR2 (80) Yes
CARD_PROGRAM_ID NUMBER (15) Yes
CARD_CODE_SET_ID NUMBER (15)
CARD_TYPE_LOOKUP_CODE VARCHAR2 (25)
CARD_PROGRAM_CURRENCY_CODE VARCHAR2 (15)
VENDOR_ID NUMBER (15)
VENDOR_SITE_ID NUMBER (15)
EXCLUDE_UNVERIFIED_FLAG VARCHAR2 (1)
EXCLUDE_PERSONAL_FLAG VARCHAR2 (1)
EXCLUDE_DISPUTED_FLAG VARCHAR2 (1)
EXCLUDE_REJECTED_FLAG VARCHAR2 (1)
EXCLUDE_ACCT_EXCEPTION_FLAG VARCHAR2 (1)
EXCLUDE_UNRECONCILED_FLAG VARCHAR2 (1)
EXCLUDE_HELD_FLAG VARCHAR2 (1)
EXCEPTION_CLEARING_CCID NUMBER (15)
ADMIN_EMPLOYEE_ID NUMBER (15)
EXPOSURE_LIMIT_AMOUNT NUMBER

DESCRIPTION VARCHAR2 (240)
ORG_ID NUMBER (15)
INACTIVE_DATE DATE

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CARD_BRAND_LOOKUP_CODE VARCHAR2 (25)
AUTO_ITEMIZE_ENABLED_FLAG VARCHAR2 (1)
CARD_EXP_TYPE_SOURCE_COL VARCHAR2 (30)
CARD_EXP_TYPE_MAP_TYPE_CODE VARCHAR2 (30)
COUNTRY_MAP_TYPE_CODE VARCHAR2 (30)
CARD_EMP_MATCHING_RULE VARCHAR2 (30)
SYSADMIN_ROLE_NAME VARCHAR2 (320)
EXPENSE_CLEARING_CCID NUMBER (15)
PAYMENT_DUE_FROM_CODE VARCHAR2 (30)
DETAIL_WAITING_DURATION NUMBER

LAST_DOWNLOAD_DATE DATE

LAST_DOWNLOAD_SIZE NUMBER

AVERAGE_DOWNLOAD_SIZE NUMBER

DOWNLOAD_COUNT NUMBER

DATA_FEED_LEVEL_CODE VARCHAR2 (30)
CARD_EXP_TYPE_DETAIL_MAP_CODE VARCHAR2 (30)
GL_PROGRAM_NAME VARCHAR2 (80)
COMPANY_NUMBER VARCHAR2 (15)
MARKET_CODE VARCHAR2 (3)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

AP.AP_CARD_PROGRAMS_ALL# references the following:

SchemaAP
TableAP_CARD_PROGRAMS_ALL
AP.AP_CARD_PROGRAMS_ALL# is referenced by following:

SchemaAPPS
SynonymAP_CARD_PROGRAMS
SynonymAP_CARD_PROGRAMS_ALL