[Home] [Help] [Dependency Information]
Object Name: | OKS_CONTRACT_UPD_DTLS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER | VARCHAR2 | (4000) | ||
CHR_ID | NUMBER | Yes | ||
CONTRACT_NUMBER | VARCHAR2 | (241) | ||
VERSION | VARCHAR2 | (81) | ||
KNOWN_AS | VARCHAR2 | (300) | ||
DESCRIPTION | VARCHAR2 | (600) | ||
PRICE_LIST | VARCHAR2 | (240) | ||
STATUS_CODE | VARCHAR2 | (30) | Yes | |
STATUS_MEANING | VARCHAR2 | (90) | Yes | |
START_DATE | DATE | |||
END_DATE | DATE | |||
FOLLOW_UP_DUE_DATE | DATE | |||
FOLLOW_UP_ACTION | VARCHAR2 | (30) | ||
FOLLOWUP_ACTION_MEANING | VARCHAR2 | (4000) | ||
ESTIMATION_PERCENT | NUMBER | |||
ESTIMATION_DATE | DATE | |||
DURATION | VARCHAR2 | (66) | ||
SUBTOTAL | VARCHAR2 | (4000) | ||
TAX | VARCHAR2 | (4000) | ||
TOTAL_AMOUNT | VARCHAR2 | (4000) | ||
NEGOTIATION_STATUS | VARCHAR2 | (80) | ||
CATEGORY_MEANING | VARCHAR2 | (90) | Yes | |
PRICE_AGREEMENT | VARCHAR2 | (240) | ||
CURRENCY | VARCHAR2 | (15) | ||
COMMENTS | VARCHAR2 | (0) | ||
NOTESTEXT | VARCHAR2 | (0) | ||
NEWSTATUSCODE | VARCHAR2 | (0) | ||
NEWREASONCODE | VARCHAR2 | (0) | ||
RENEWAL_COMMENT | VARCHAR2 | (600) |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER
, CHR_ID
, CONTRACT_NUMBER
, VERSION
, KNOWN_AS
, DESCRIPTION
, PRICE_LIST
, STATUS_CODE
, STATUS_MEANING
, START_DATE
, END_DATE
, FOLLOW_UP_DUE_DATE
, FOLLOW_UP_ACTION
, FOLLOWUP_ACTION_MEANING
, ESTIMATION_PERCENT
, ESTIMATION_DATE
, DURATION
, SUBTOTAL
, TAX
, TOTAL_AMOUNT
, NEGOTIATION_STATUS
, CATEGORY_MEANING
, PRICE_AGREEMENT
, CURRENCY
, COMMENTS
, NOTESTEXT
, NEWSTATUSCODE
, NEWREASONCODE
, RENEWAL_COMMENT
FROM APPS.OKS_CONTRACT_UPD_DTLS_V;
APPS.OKS_CONTRACT_UPD_DTLS_V is not referenced by any database object
|
|
|