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

TABLE: OKC.OKC_K_HEADERS_ALL_BH

Object Details
Object Name: OKC_K_HEADERS_ALL_BH
Object Type: TABLE
Owner: OKC
Subobject Name:
Status: VALID


This is a mirror image of base table OKC_K_HEADERS_ALL_B, please refer to the base table for detailed column level information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKC_K_HEADERS_ALL_BH_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTRACT_NUMBER
ColumnCONTRACT_NUMBER_MODIFIER
ColumnMAJOR_VERSION
OKC_K_HEADERS_ALL_BH_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
ColumnMAJOR_VERSION
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes
CONTRACT_NUMBER VARCHAR2 (120) Yes
AUTHORING_ORG_ID NUMBER
Yes
ARCHIVED_YN VARCHAR2 (3) Yes
DELETED_YN VARCHAR2 (3) Yes
TEMPLATE_YN VARCHAR2 (3) Yes
CHR_TYPE VARCHAR2 (30) Yes
MAJOR_VERSION NUMBER (4) Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
CHR_ID_RESPONSE NUMBER

CHR_ID_AWARD NUMBER

CHR_ID_RENEWED NUMBER

STS_CODE VARCHAR2 (30) Yes
INV_ORGANIZATION_ID NUMBER
Yes
QCL_ID NUMBER

SCS_CODE VARCHAR2 (30) Yes
TRN_CODE VARCHAR2 (30)
CURRENCY_CODE VARCHAR2 (15)
CUST_PO_NUMBER_REQ_YN VARCHAR2 (3)
PRE_PAY_REQ_YN VARCHAR2 (3)
CUST_PO_NUMBER VARCHAR2 (150)
DPAS_RATING VARCHAR2 (24)
TEMPLATE_USED VARCHAR2 (120)
DATE_APPROVED DATE

DATETIME_CANCELLED DATE

AUTO_RENEW_DAYS NUMBER (4)
DATE_ISSUED DATE

DATETIME_RESPONDED DATE

RFP_TYPE VARCHAR2 (30)
KEEP_ON_MAIL_LIST VARCHAR2 (3)
SET_ASIDE_PERCENT NUMBER (5)
RESPONSE_COPIES_REQ NUMBER (2)
DATE_CLOSE_PROJECTED DATE

DATETIME_PROPOSED DATE

DATE_SIGNED DATE

DATE_TERMINATED DATE

DATE_RENEWED DATE

START_DATE DATE

END_DATE DATE

BUY_OR_SELL VARCHAR2 (3)
ISSUE_OR_RECEIVE VARCHAR2 (3)
LAST_UPDATE_LOGIN NUMBER (15)
ESTIMATED_AMOUNT NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (90)
ATTRIBUTE1 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)
ATTRIBUTE10 VARCHAR2 (450)
ATTRIBUTE11 VARCHAR2 (450)
ATTRIBUTE12 VARCHAR2 (450)
ATTRIBUTE13 VARCHAR2 (450)
ATTRIBUTE14 VARCHAR2 (450)
ATTRIBUTE15 VARCHAR2 (450)
SECURITY_GROUP_ID NUMBER

CHR_ID_RENEWED_TO NUMBER

ESTIMATED_AMOUNT_RENEWED NUMBER

CURRENCY_CODE_RENEWED VARCHAR2 (15)
APPLICATION_ID VARCHAR2 (240)
RESOLVED_UNTIL DATE

ORIG_SYSTEM_SOURCE_CODE VARCHAR2 (30)
ORIG_SYSTEM_ID1 NUMBER

ORIG_SYSTEM_REFERENCE1 VARCHAR2 (30)
UPG_ORIG_SYSTEM_REF VARCHAR2 (60)
UPG_ORIG_SYSTEM_REF_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

PRICE_LIST_ID NUMBER

PRICING_DATE DATE

TOTAL_LINE_LIST_PRICE NUMBER

SIGN_BY_DATE DATE

USER_ESTIMATED_AMOUNT NUMBER

GOVERNING_CONTRACT_YN VARCHAR2 (3)
DOCUMENT_ID NUMBER

CONVERSION_TYPE VARCHAR2 (30)
CONVERSION_RATE NUMBER

CONVERSION_RATE_DATE DATE

CONVERSION_EURO_RATE NUMBER

CUST_ACCT_ID NUMBER (15)
BILL_TO_SITE_USE_ID NUMBER (15)
INV_RULE_ID NUMBER (15)
RENEWAL_TYPE_CODE VARCHAR2 (30)
RENEWAL_NOTIFY_TO NUMBER

RENEWAL_END_DATE DATE

SHIP_TO_SITE_USE_ID NUMBER (15)
PAYMENT_TERM_ID NUMBER (15)
APPROVAL_TYPE VARCHAR2 (30)
TERM_CANCEL_SOURCE VARCHAR2 (30)
PAYMENT_INSTRUCTION_TYPE VARCHAR2 (3)
ORG_ID NUMBER
Yes
CANCELLED_AMOUNT NUMBER

Query Text

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


SELECT ID
,      CONTRACT_NUMBER
,      AUTHORING_ORG_ID
,      ARCHIVED_YN
,      DELETED_YN
,      TEMPLATE_YN
,      CHR_TYPE
,      MAJOR_VERSION
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CONTRACT_NUMBER_MODIFIER
,      CHR_ID_RESPONSE
,      CHR_ID_AWARD
,      CHR_ID_RENEWED
,      STS_CODE
,      INV_ORGANIZATION_ID
,      QCL_ID
,      SCS_CODE
,      TRN_CODE
,      CURRENCY_CODE
,      CUST_PO_NUMBER_REQ_YN
,      PRE_PAY_REQ_YN
,      CUST_PO_NUMBER
,      DPAS_RATING
,      TEMPLATE_USED
,      DATE_APPROVED
,      DATETIME_CANCELLED
,      AUTO_RENEW_DAYS
,      DATE_ISSUED
,      DATETIME_RESPONDED
,      RFP_TYPE
,      KEEP_ON_MAIL_LIST
,      SET_ASIDE_PERCENT
,      RESPONSE_COPIES_REQ
,      DATE_CLOSE_PROJECTED
,      DATETIME_PROPOSED
,      DATE_SIGNED
,      DATE_TERMINATED
,      DATE_RENEWED
,      START_DATE
,      END_DATE
,      BUY_OR_SELL
,      ISSUE_OR_RECEIVE
,      LAST_UPDATE_LOGIN
,      ESTIMATED_AMOUNT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      CHR_ID_RENEWED_TO
,      ESTIMATED_AMOUNT_RENEWED
,      CURRENCY_CODE_RENEWED
,      APPLICATION_ID
,      RESOLVED_UNTIL
,      ORIG_SYSTEM_SOURCE_CODE
,      ORIG_SYSTEM_ID1
,      ORIG_SYSTEM_REFERENCE1
,      UPG_ORIG_SYSTEM_REF
,      UPG_ORIG_SYSTEM_REF_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PRICE_LIST_ID
,      PRICING_DATE
,      TOTAL_LINE_LIST_PRICE
,      SIGN_BY_DATE
,      USER_ESTIMATED_AMOUNT
,      GOVERNING_CONTRACT_YN
,      DOCUMENT_ID
,      CONVERSION_TYPE
,      CONVERSION_RATE
,      CONVERSION_RATE_DATE
,      CONVERSION_EURO_RATE
,      CUST_ACCT_ID
,      BILL_TO_SITE_USE_ID
,      INV_RULE_ID
,      RENEWAL_TYPE_CODE
,      RENEWAL_NOTIFY_TO
,      RENEWAL_END_DATE
,      SHIP_TO_SITE_USE_ID
,      PAYMENT_TERM_ID
,      APPROVAL_TYPE
,      TERM_CANCEL_SOURCE
,      PAYMENT_INSTRUCTION_TYPE
,      ORG_ID
,      CANCELLED_AMOUNT
FROM OKC.OKC_K_HEADERS_ALL_BH;

Dependencies

[top of page]

OKC.OKC_K_HEADERS_ALL_BH does not reference any database object

OKC.OKC_K_HEADERS_ALL_BH is referenced by following:

SchemaAPPS
SynonymOKC_K_HEADERS_ALL_BH
SynonymOKC_K_HEADERS_BH