[Home] [Help] [Dependency Information]

TABLE: OKC.OKC_K_LINES_BH

Object Details

Object Name:	OKC_K_LINES_BH
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_K_LINES_BH
Subobject Name:
Status:	VALID

This is a mirror image of base table OKC_K_LINES_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_LINES_BH_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID MAJOR_VERSION
OKC_K_LINES_BH_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHR_ID
OKC_K_LINES_BH_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DNZ_CHR_ID

Columns

Query Text

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

SELECT ID
,      LINE_NUMBER
,      CHR_ID
,      CLE_ID
,      CLE_ID_RENEWED
,      DNZ_CHR_ID
,      DISPLAY_SEQUENCE
,      STS_CODE
,      TRN_CODE
,      LSE_ID
,      EXCEPTION_YN
,      MAJOR_VERSION
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      HIDDEN_IND
,      PRICE_UNIT
,      PRICE_UNIT_PERCENT
,      PRICE_NEGOTIATED
,      PRICE_LEVEL_IND
,      INVOICE_LINE_LEVEL_IND
,      DPAS_RATING
,      TEMPLATE_USED
,      PRICE_TYPE
,      UOM_CODE
,      CURRENCY_CODE
,      LAST_UPDATE_LOGIN
,      DATE_TERMINATED
,      START_DATE
,      END_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      CLE_ID_RENEWED_TO
,      PRICE_NEGOTIATED_RENEWED
,      CURRENCY_CODE_RENEWED
,      DATE_RENEWED
,      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
,      PRICE_LIST_LINE_ID
,      LINE_LIST_PRICE
,      ITEM_TO_PRICE_YN
,      PRICING_DATE
,      PRICE_BASIS_YN
,      CONFIG_HEADER_ID
,      CONFIG_REVISION_NUMBER
,      CONFIG_COMPLETE_YN
,      CONFIG_VALID_YN
,      CONFIG_TOP_MODEL_LINE_ID
,      CONFIG_ITEM_TYPE
,      CONFIG_ITEM_ID
,      SERVICE_ITEM_YN
,      PH_PRICING_TYPE
,      PH_PRICE_BREAK_BASIS
,      PH_MIN_QTY
,      PH_MIN_AMT
,      PH_QP_REFERENCE_ID
,      PH_VALUE
,      PH_ENFORCE_PRICE_LIST_YN
,      PH_ADJUSTMENT
,      PH_INTEGRATED_WITH_QP
,      CUST_ACCT_ID
,      BILL_TO_SITE_USE_ID
,      INV_RULE_ID
,      LINE_RENEWAL_TYPE_CODE
,      SHIP_TO_SITE_USE_ID
,      PAYMENT_TERM_ID
,      DATE_CANCELLED
,      TERM_CANCEL_SOURCE
,      PAYMENT_INSTRUCTION_TYPE
,      ANNUALIZED_FACTOR
,      CANCELLED_AMOUNT
FROM OKC.OKC_K_LINES_BH;

Dependencies

[top of page]

OKC.OKC_K_LINES_BH does not reference any database object

OKC.OKC_K_LINES_BH is referenced by following:

OKC

OKC_K_LINES_BH#