[Home] [Help] [Dependency Information]
Object Name: | OKI_PRICING_RULES |
---|---|
Object Type: | TABLE |
Owner: | OKI |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
OKI.OKI_PRICING_RULES does not reference any database object
OKI.OKI_PRICING_RULES is referenced by following:
|
|
|