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

VIEW: AP.AP_CC_ACCEPTORS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CARD_ACCEPTOR_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
CARD_PROGRAM_ID NUMBER (15) Yes
ACCEPTOR_NAME VARCHAR2 (200)
ACCEPTOR_STREET_ADDRESS VARCHAR2 (240)
ACCEPTOR_CITY VARCHAR2 (60)
ACCEPTOR_STATE_PROVINCE VARCHAR2 (60)
ACCEPTOR_POSTAL_CODE VARCHAR2 (60)
ACCEPTOR_COUNTRY_CODE VARCHAR2 (60)
ACCEPTOR_BUSINESS_CODE VARCHAR2 (100)
ACCEPTOR_TAXPAYER_NUMBER VARCHAR2 (20)
ACCEPTOR_VAT_NUMBER VARCHAR2 (20)
ACCEPTOR_DUNS_NUMBER VARCHAR2 (15)
DETAIL_WAITING_DURATION NUMBER
Yes
FEED_CARD_ACCEPTOR_ID VARCHAR2 (80)
ACCEPTOR_TYPE VARCHAR2 (80)
ACCEPTOR_EMAIL VARCHAR2 (80)
ACCEPTOR_TELEPHONE VARCHAR2 (80)
Query Text

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


SELECT CARD_ACCEPTOR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      CARD_PROGRAM_ID
,      ACCEPTOR_NAME
,      ACCEPTOR_STREET_ADDRESS
,      ACCEPTOR_CITY
,      ACCEPTOR_STATE_PROVINCE
,      ACCEPTOR_POSTAL_CODE
,      ACCEPTOR_COUNTRY_CODE
,      ACCEPTOR_BUSINESS_CODE
,      ACCEPTOR_TAXPAYER_NUMBER
,      ACCEPTOR_VAT_NUMBER
,      ACCEPTOR_DUNS_NUMBER
,      DETAIL_WAITING_DURATION
,      FEED_CARD_ACCEPTOR_ID
,      ACCEPTOR_TYPE
,      ACCEPTOR_EMAIL
,      ACCEPTOR_TELEPHONE
FROM AP.AP_CC_ACCEPTORS#;

Dependencies

[top of page]

AP.AP_CC_ACCEPTORS# references the following:

SchemaAP
TableAP_CC_ACCEPTORS
AP.AP_CC_ACCEPTORS# is referenced by following:

SchemaAPPS
SynonymAP_CC_ACCEPTORS