[Home] [Help] [Dependency Information]
Object Name: | OKL_CONDTLS_WELCOME_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_CONDTLS_WELCOME_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 |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
INV_ORGANIZATION_ID | NUMBER | Yes | Foreign key to MTL_SYSTEM_ITEMS. | |
STS_CODE | VARCHAR2 | (30) | Yes | Status of Contraact Header. |
QCL_ID | NUMBER | ID of QA check list applicable to this contract. | ||
SCS_CODE | VARCHAR2 | (30) | Yes | Contract''s subclass. |
CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract Number |
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | A unique internal name for the contract number. | |
SHORT_DESCRIPTION | VARCHAR2 | (600) | User entered free format abbreviated text description. | |
COMMENTS | VARCHAR2 | (1995) | User entered comments | |
DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
DATE_APPROVED | DATE | Date contract was approved. | ||
DATE_ISSUED | DATE | Date contract Issued. | ||
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
AUTHORING_ORG_ID | NUMBER | Yes | Identifier of the Operating Unit to which the contract belongs. This is the same as that of the responsibility in case the contract is created manually. If the contract is created from another contract (for example, through a copy operation), then this is the same as that of the source contract | |
KHR_ID | NUMBER | Foreign key to view OKL_K_HEADERS_V | ||
PDT_ID | NUMBER | Foreign key to view OKL_PRODUCTS_V | ||
CUSTOMER_NAME | VARCHAR2 | (360) | Yes | Name of this party |
CONTRACT_STATUS | VARCHAR2 | (90) | Yes | Short meaning associated with code value. |
PRDUCT_NAME | VARCHAR2 | (150) | This is the name for the Product. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, INV_ORGANIZATION_ID
, STS_CODE
, QCL_ID
, SCS_CODE
, CONTRACT_NUMBER
, CURRENCY_CODE
, CONTRACT_NUMBER_MODIFIER
, SHORT_DESCRIPTION
, COMMENTS
, DESCRIPTION
, DATE_APPROVED
, DATE_ISSUED
, START_DATE
, END_DATE
, AUTHORING_ORG_ID
, KHR_ID
, PDT_ID
, CUSTOMER_NAME
, CONTRACT_STATUS
, PRDUCT_NAME
FROM APPS.OKL_CONDTLS_WELCOME_UV;
APPS.OKL_CONDTLS_WELCOME_UV is not referenced by any database object
|
|
|