[Home] [Help] [Dependency Information]
Object Name: | ZX_REP_CONTEXT_T# |
---|---|
Object Type: | VIEW |
Owner: | ZX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REP_CONTEXT_ID | NUMBER | (15) | Yes | |
REP_ENTITY_ID | NUMBER | (15) | ||
ORG_INFORMATION2 | VARCHAR2 | (150) | ||
REP_CONTEXT_ENTITY_LOCATION_ID | NUMBER | (15) | ||
REP_CONTEXT_ENTITY_NAME | VARCHAR2 | (240) | ||
REP_CONTEXT_ENTITY_CITY | VARCHAR2 | (120) | ||
REP_CONTEXT_ENTITY_COUNTY | VARCHAR2 | (120) | ||
REP_CONTEXT_ENTITY_STATE | VARCHAR2 | (120) | ||
REP_CONTEXT_ENTITY_PROVINCE | VARCHAR2 | (120) | ||
REP_CONTEXT_ENTITY_ADDRESS1 | VARCHAR2 | (240) | ||
REP_CONTEXT_ENTITY_ADDRESS2 | VARCHAR2 | (240) | ||
REP_CONTEXT_ENTITY_ADDRESS3 | VARCHAR2 | (240) | ||
REP_CONTEXT_ENTITY_COUNTRY | VARCHAR2 | (60) | ||
REP_CONTEXT_ENTITY_POSTAL_CODE | VARCHAR2 | (30) | ||
REP_CONTEXT_ENTITY_TEL_NUMBER | VARCHAR2 | (60) | ||
REP_CONTEXT_LVL_MNG | VARCHAR2 | (80) | ||
REP_CONTEXT_LVL_CODE | VARCHAR2 | (30) | ||
EXTRACT_SUMMARY_CODE | VARCHAR2 | (30) | ||
MATRIX_REPORT_FLAG | VARCHAR2 | (1) | ||
LEGAL_CONTACT_PRE_NAME_ADJUNCT | VARCHAR2 | (30) | ||
LEGAL_CONTACT_PARTY_NAME | VARCHAR2 | (360) | ||
TAXPAYER_ID | VARCHAR2 | (30) | ||
LEGAL_CONTACT_TITLE | VARCHAR2 | (100) | ||
ACTIVITY_CODE | VARCHAR2 | (150) | ||
SUB_ACTIVITY_CODE | VARCHAR2 | (150) | ||
INCEPTION_DATE | DATE | |||
LEGAL_CONTACT_PARTY_NUM | VARCHAR2 | (30) | ||
LEGAL_AUTH_ADDRESS_LINE2 | VARCHAR2 | (240) | ||
LEGAL_AUTH_ADDRESS_LINE3 | VARCHAR2 | (240) | ||
LEGAL_AUTH_CITY | VARCHAR2 | (60) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_LOGIN_ID | NUMBER | |||
LEGAL_AUTHORITY_NAME | VARCHAR2 | (360) |
Cut, paste (and edit) the following text to query this object:
SELECT REP_CONTEXT_ID
, REP_ENTITY_ID
, ORG_INFORMATION2
, REP_CONTEXT_ENTITY_LOCATION_ID
, REP_CONTEXT_ENTITY_NAME
, REP_CONTEXT_ENTITY_CITY
, REP_CONTEXT_ENTITY_COUNTY
, REP_CONTEXT_ENTITY_STATE
, REP_CONTEXT_ENTITY_PROVINCE
, REP_CONTEXT_ENTITY_ADDRESS1
, REP_CONTEXT_ENTITY_ADDRESS2
, REP_CONTEXT_ENTITY_ADDRESS3
, REP_CONTEXT_ENTITY_COUNTRY
, REP_CONTEXT_ENTITY_POSTAL_CODE
, REP_CONTEXT_ENTITY_TEL_NUMBER
, REP_CONTEXT_LVL_MNG
, REP_CONTEXT_LVL_CODE
, EXTRACT_SUMMARY_CODE
, MATRIX_REPORT_FLAG
, LEGAL_CONTACT_PRE_NAME_ADJUNCT
, LEGAL_CONTACT_PARTY_NAME
, TAXPAYER_ID
, LEGAL_CONTACT_TITLE
, ACTIVITY_CODE
, SUB_ACTIVITY_CODE
, INCEPTION_DATE
, LEGAL_CONTACT_PARTY_NUM
, LEGAL_AUTH_ADDRESS_LINE2
, LEGAL_AUTH_ADDRESS_LINE3
, LEGAL_AUTH_CITY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, LEGAL_AUTHORITY_NAME
FROM ZX.ZX_REP_CONTEXT_T#;
|
|
|