eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OKI.OKI_PRICING_RULES

Object Details

Object Name:	OKI_PRICING_RULES
Object Type:	TABLE
Owner:	OKI
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKI_PRICING_RULES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHR_ID
OKI_PRICING_RULES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DNZ_CHR_ID CLE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONTRACT_NUMBER	VARCHAR2	(120)		Contract number
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)		Contract number modifier
COMPLETE_CONTRACT_NUMBER	VARCHAR2	(240)		Complete contract number
CHR_ID	NUMBER		Yes	Contract header id
CLE_ID	NUMBER			Contract line id
DNZ_CHR_ID	NUMBER			Denormalized contract header id
RGP_ID	NUMBER			Rule group id
AGREEMENT_NAME	VARCHAR2	(240)		Agreement name
PRICE_LIST	VARCHAR2	(240)		Price list name
ACCOUNTING_RULE	VARCHAR2	(30)		Accounting rule
PAYMENT_TERM	VARCHAR2	(15)		Payment term
INVOICING_RULE	VARCHAR2	(30)		Invoicing rule
GRACE_DURATION	NUMBER	(22)		Grace period duration
GRACE_PERIOD_CODE	VARCHAR2	(30)		Grace period code
CREATION_DATE	DATE			standard who column
LAST_UPDATE_DATE	DATE			standard who column
SECURITY_GROUP_ID	NUMBER			Concurrent Manager audit column.
AGREEMENT_ID	NUMBER
LIST_HEADER_ID	NUMBER
TERM_ID	NUMBER

Query Text

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


SELECT CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_CONTRACT_NUMBER
,      CHR_ID
,      CLE_ID
,      DNZ_CHR_ID
,      RGP_ID
,      AGREEMENT_NAME
,      PRICE_LIST
,      ACCOUNTING_RULE
,      PAYMENT_TERM
,      INVOICING_RULE
,      GRACE_DURATION
,      GRACE_PERIOD_CODE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      SECURITY_GROUP_ID
,      AGREEMENT_ID
,      LIST_HEADER_ID
,      TERM_ID
FROM OKI.OKI_PRICING_RULES;