[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
FND Design Data:	OKC.OKC_K_HEADERS_ALL_BH
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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_K_HEADERS_ALL_BH_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTRACT_NUMBER CONTRACT_NUMBER_MODIFIER MAJOR_VERSION
OKC_K_HEADERS_ALL_BH_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID MAJOR_VERSION

Columns

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:

OKC

OKC_K_HEADERS_ALL_BH#