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

VIEW: APPS.OKI_PRICING_RULES_V

Object Details
Object Name: OKI_PRICING_RULES_V
Object Type: VIEW
Owner: APPS
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.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTRACT_NUMBER VARCHAR2 (120)
Contract number
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier
COMPLETE_CONTRACT_NUMBER VARCHAR2 (241)
Complete contract number
CHR_ID NUMBER
Yes Contract header id
CLE_ID VARCHAR2 (0)
Contract line id
DNZ_CHR_ID VARCHAR2 (0)
Denormalized contract header id
RGP_ID VARCHAR2 (0)
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

Grace duration
GRACE_PERIOD_CODE VARCHAR2 (30)
Grace period code
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
FROM APPS.OKI_PRICING_RULES_V;

Dependencies

[top of page]

APPS.OKI_PRICING_RULES_V references the following:

SchemaAPPS
SynonymOE_AGREEMENTS_TL
SynonymOKI_SALES_K_HDRS
SynonymQP_LIST_HEADERS_TL
SynonymRA_RULES
SynonymRA_TERMS_TL

APPS.OKI_PRICING_RULES_V is not referenced by any database object