[Home] [Help] [Dependency Information]
Object Name: | OKL_CS_RELATED_CONTRACT_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_CS_RELATED_CONTRACT_UV |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
PARENT_GROUP_ID | NUMBER | Yes | Parent Group ID | |
CONTRACT_ID | NUMBER | Yes | Contract ID | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object Version Number |
STATUS_CODE | VARCHAR2 | (30) | Yes | Status Code |
STATUS_MEANING | VARCHAR2 | (90) | Yes | Status Meaning |
SUBCLASS_CODE | VARCHAR2 | (30) | Yes | Subclass Code |
SUBCLASS_MEANING | VARCHAR2 | (90) | Yes | Subclass Meaning |
QCL_ID | NUMBER | QCL ID | ||
CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract Number |
CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | Contract number Modifier | |
CONTRACT_AMOUNT | NUMBER | Contract Amount | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CUST_PO_NUMBER_REQ_YN | VARCHAR2 | (3) | Customer PO Number Required Y/N | |
PRE_PAY_REQ_YN | VARCHAR2 | (3) | Pre Pay Required Y/N | |
CUST_PO_NUMBER | VARCHAR2 | (150) | Customer PO Number | |
SHORT_DESCRIPTION | VARCHAR2 | (600) | Short Description | |
COMMENTS | VARCHAR2 | (1995) | Comments | |
DESCRIPTION | VARCHAR2 | (1995) | Description | |
DPAS_RATING | VARCHAR2 | (24) | DPAS Rating | |
KNOWN_AS | VARCHAR2 | (300) | Known As | |
TEMPLATE_YN | VARCHAR2 | (3) | Yes | Template Y/N |
TEMPLATE_USED | VARCHAR2 | (120) | Template Used | |
DATE_APPROVED | DATE | Date Approved | ||
DATETIME_CANCELLED | DATE | Date Time Cancelled | ||
AUTO_RENEW_DAYS | NUMBER | (4) | Auto Renew Days | |
DATE_SIGNED | DATE | Date Signed | ||
DATE_TERMINATED | DATE | Date Terminated | ||
DATE_RENEWED | DATE | Date Renewed | ||
TRN_CODE | VARCHAR2 | (30) | Transaction Code | |
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
AUTHORING_ORG_ID | NUMBER | Yes | Authoring Operating Unit ID | |
APPLICATION_ID | NUMBER | Application ID | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PARENT_GROUP_ID
, CONTRACT_ID
, OBJECT_VERSION_NUMBER
, STATUS_CODE
, STATUS_MEANING
, SUBCLASS_CODE
, SUBCLASS_MEANING
, QCL_ID
, CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER
, CONTRACT_AMOUNT
, CURRENCY_CODE
, CUST_PO_NUMBER_REQ_YN
, PRE_PAY_REQ_YN
, CUST_PO_NUMBER
, SHORT_DESCRIPTION
, COMMENTS
, DESCRIPTION
, DPAS_RATING
, KNOWN_AS
, TEMPLATE_YN
, TEMPLATE_USED
, DATE_APPROVED
, DATETIME_CANCELLED
, AUTO_RENEW_DAYS
, DATE_SIGNED
, DATE_TERMINATED
, DATE_RENEWED
, TRN_CODE
, START_DATE
, END_DATE
, AUTHORING_ORG_ID
, APPLICATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKL_CS_RELATED_CONTRACT_UV;
APPS.OKL_CS_RELATED_CONTRACT_UV is not referenced by any database object
|
|
|