Skip to content

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

VIEW: OKC.OKC_REP_IMP_CONTRACTS_T#

Object Details
Object Name: OKC_REP_IMP_CONTRACTS_T#
Object Type: VIEW
Owner: OKC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
IMP_CONTRACT_ID NUMBER
Yes
CONTRACT_ID NUMBER

CONTRACT_NUMBER VARCHAR2 (151)
CONTRACT_NAME VARCHAR2 (451)
DESCRIPTION VARCHAR2 (2001)
CONTRACT_TYPE VARCHAR2 (30)
AUTHORING_PARTY_CODE VARCHAR2 (30)
CONTRACT_STATUS_CODE VARCHAR2 (30)
VERSION_COMMENTS VARCHAR2 (2001)
CONTRACT_EFFECTIVE_DATE VARCHAR2 (30)
CONTRACT_EXPIRATION_DATE VARCHAR2 (30)
CURRENCY_CODE VARCHAR2 (15)
CONTRACT_AMOUNT VARCHAR2 (30)
ORG_NAME VARCHAR2 (240)
ORG_ID NUMBER (15)
OWNER_USER_NAME VARCHAR2 (100)
OWNER_USER_ID NUMBER (15)
PHYSICAL_LOCATION VARCHAR2 (2001)
KEYWORDS VARCHAR2 (2001)
CONTRACT_TYPE_TXT VARCHAR2 (150)
AUTHORING_PARTY_TXT VARCHAR2 (80)
CONTRACT_STATUS_TXT VARCHAR2 (80)
VALID_FLAG VARCHAR2 (1)
ORIG_SYSTEM_REFERENCE_CODE VARCHAR2 (31)
ORIG_SYSTEM_REFERENCE_ID1 VARCHAR2 (101)
ORIG_SYSTEM_REFERENCE_ID2 VARCHAR2 (101)
CREATION_DATE DATE

PROGRAM_ID NUMBER (15)
PROGRAM_LOGIN_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
REQUEST_ID NUMBER (15)
ATTRIBUTE1 VARCHAR2 (450)
ATTRIBUTE10 VARCHAR2 (450)
ATTRIBUTE11 VARCHAR2 (450)
ATTRIBUTE12 VARCHAR2 (450)
ATTRIBUTE13 VARCHAR2 (450)
ATTRIBUTE14 VARCHAR2 (450)
ATTRIBUTE15 VARCHAR2 (450)
ATTRIBUTE2 VARCHAR2 (450)
ATTRIBUTE3 VARCHAR2 (450)
ATTRIBUTE4 VARCHAR2 (450)
ATTRIBUTE5 VARCHAR2 (450)
ATTRIBUTE6 VARCHAR2 (450)
ATTRIBUTE7 VARCHAR2 (450)
ATTRIBUTE8 VARCHAR2 (450)
ATTRIBUTE9 VARCHAR2 (450)
ATTRIBUTE_CATEGORY VARCHAR2 (90)
CANCELLATION_COMMENTS VARCHAR2 (2000)
CANCELLATION_DATE DATE

CONTRACT_VERSION_NUM NUMBER

EXPIRE_NTF_FLAG VARCHAR2 (1)
EXPIRE_NTF_PERIOD NUMBER

LATEST_SIGNED_VER_NUMBER NUMBER

NOTIFY_CONTACT_ROLE_ID NUMBER

NOTIFY_CONTACT_ROLE_TXT VARCHAR2 (450)
OVERALL_RISK_CODE VARCHAR2 (30)
OVERALL_RISK_TXT VARCHAR2 (450)
REFERENCE_DOCUMENT_ID NUMBER

REFERENCE_DOCUMENT_NUMBER VARCHAR2 (150)
REFERENCE_DOCUMENT_TYPE VARCHAR2 (30)
RUN_ID NUMBER

SOURCE_CODE VARCHAR2 (150)
TERMINATION_COMMENTS VARCHAR2 (2000)
TERMINATION_DATE DATE

Query Text

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


SELECT IMP_CONTRACT_ID
,      CONTRACT_ID
,      CONTRACT_NUMBER
,      CONTRACT_NAME
,      DESCRIPTION
,      CONTRACT_TYPE
,      AUTHORING_PARTY_CODE
,      CONTRACT_STATUS_CODE
,      VERSION_COMMENTS
,      CONTRACT_EFFECTIVE_DATE
,      CONTRACT_EXPIRATION_DATE
,      CURRENCY_CODE
,      CONTRACT_AMOUNT
,      ORG_NAME
,      ORG_ID
,      OWNER_USER_NAME
,      OWNER_USER_ID
,      PHYSICAL_LOCATION
,      KEYWORDS
,      CONTRACT_TYPE_TXT
,      AUTHORING_PARTY_TXT
,      CONTRACT_STATUS_TXT
,      VALID_FLAG
,      ORIG_SYSTEM_REFERENCE_CODE
,      ORIG_SYSTEM_REFERENCE_ID1
,      ORIG_SYSTEM_REFERENCE_ID2
,      CREATION_DATE
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      CANCELLATION_COMMENTS
,      CANCELLATION_DATE
,      CONTRACT_VERSION_NUM
,      EXPIRE_NTF_FLAG
,      EXPIRE_NTF_PERIOD
,      LATEST_SIGNED_VER_NUMBER
,      NOTIFY_CONTACT_ROLE_ID
,      NOTIFY_CONTACT_ROLE_TXT
,      OVERALL_RISK_CODE
,      OVERALL_RISK_TXT
,      REFERENCE_DOCUMENT_ID
,      REFERENCE_DOCUMENT_NUMBER
,      REFERENCE_DOCUMENT_TYPE
,      RUN_ID
,      SOURCE_CODE
,      TERMINATION_COMMENTS
,      TERMINATION_DATE
FROM OKC.OKC_REP_IMP_CONTRACTS_T#;

Dependencies

[top of page]

OKC.OKC_REP_IMP_CONTRACTS_T# references the following:

SchemaOKC
TableOKC_REP_IMP_CONTRACTS_T
OKC.OKC_REP_IMP_CONTRACTS_T# is referenced by following:

SchemaAPPS
SynonymOKC_REP_IMP_CONTRACTS_T