[Home] [Help] [Dependency Information]

TABLE: OKC.OKC_PRICE_ADJUSTMENTS_H

Object Details

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

This is a mirror image of base table OKC_PRICE_ADJUSTMENTS, 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_PRICE_ADJUSTMENTS_H_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID MAJOR_VERSION
OKC_PRICE_ADJUSTMENTS_H_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHR_ID MAJOR_VERSION
OKC_PRICE_ADJUSTMENTS_H_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLE_ID MAJOR_VERSION

Columns

Query Text

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

SELECT ID
,      PAT_ID
,      CHR_ID
,      CLE_ID
,      BSL_ID
,      BCL_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      MODIFIED_FROM
,      MODIFIED_TO
,      MODIFIER_MECHANISM_TYPE_CODE
,      OPERAND
,      ARITHMETIC_OPERATOR
,      AUTOMATIC_FLAG
,      UPDATE_ALLOWED
,      UPDATED_FLAG
,      APPLIED_FLAG
,      ON_INVOICE_FLAG
,      PRICING_PHASE_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      OBJECT_VERSION_NUMBER
,      LIST_HEADER_ID
,      LIST_LINE_ID
,      LIST_LINE_TYPE_CODE
,      CHANGE_REASON_CODE
,      CHANGE_REASON_TEXT
,      ESTIMATED_FLAG
,      ADJUSTED_AMOUNT
,      CHARGE_TYPE_CODE
,      CHARGE_SUBTYPE_CODE
,      RANGE_BREAK_QUANTITY
,      ACCRUAL_CONVERSION_RATE
,      PRICING_GROUP_SEQUENCE
,      ACCRUAL_FLAG
,      LIST_LINE_NO
,      SOURCE_SYSTEM_CODE
,      BENEFIT_QTY
,      BENEFIT_UOM_CODE
,      EXPIRATION_DATE
,      MODIFIER_LEVEL_CODE
,      PRICE_BREAK_TYPE_CODE
,      SUBSTITUTION_ATTRIBUTE
,      PRORATION_TYPE_CODE
,      INCLUDE_ON_RETURNS_FLAG
,      REBATE_TRANSACTION_TYPE_CODE
,      MAJOR_VERSION
FROM OKC.OKC_PRICE_ADJUSTMENTS_H;

Dependencies

[top of page]

OKC.OKC_PRICE_ADJUSTMENTS_H does not reference any database object

OKC.OKC_PRICE_ADJUSTMENTS_H is referenced by following:

APPS

OKC_PRICE_ADJUSTMENTS_H