[Home] [Help] [Dependency Information]
Object Name: | OKC_LINE_STYLES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_LINE_STYLES_V |
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) | Auto-generated by Headstart Utilities | |
ID | NUMBER | Yes | Primary key column. | |
LTY_CODE | VARCHAR2 | (30) | Yes | Foreign key to FND_LOOKUP_VALUES. |
LSE_PARENT_ID | NUMBER | Parent ID. | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Indicates a value was changed in another language. Not fully implemented in 11i |
NAME | VARCHAR2 | (150) | Line style name. | |
DESCRIPTION | VARCHAR2 | (1995) | User entered free format text description. | |
PRICED_YN | VARCHAR2 | (3) | Yes/No field. | |
RECURSIVE_YN | VARCHAR2 | (3) | Indicates whether the line style is recursive or not | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column. | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
LSE_TYPE | VARCHAR2 | (10) | Yes | Line style type 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. | |
APPLICATION_ID | NUMBER | Application Id | ||
PROTECTED_YN | VARCHAR2 | (3) | Yes | Indicates if a line style is to be protected from the user updates. This column is used by the application for protecting certain seeded line styles. |
ITEM_TO_PRICE_YN | VARCHAR2 | (3) | Indicates whether a contract line with this linestyle contains the item being priced. For example, if the top line contains the Service 'Gold Support' and there are two child lines indicating Deployment at USA and India, then the Service line contains the item being priced. In this example, the Deployment lines are the level at which pricing is done and the corresponding line style will have PRICED_YN set to 'Y' | |
PRICE_BASIS_YN | VARCHAR2 | (3) | Indicates whether a contract line with this linestyle is the basis for the item being priced. For example, if the top line contains the Service 'Gold Support' and this is for a Product "Oracle 8i" in the child line and the price of the Service is dependent on the price of the Product, then the the Product line has this flag set to 'Y' and the Service line has PRICED_ITEM_YN set to 'Y' | |
ACCESS_LEVEL | VARCHAR2 | (1) | Indicates the protection level for the record. | |
SERVICE_ITEM_YN | VARCHAR2 | (3) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, LTY_CODE
, LSE_PARENT_ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, NAME
, DESCRIPTION
, PRICED_YN
, RECURSIVE_YN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LSE_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, APPLICATION_ID
, PROTECTED_YN
, ITEM_TO_PRICE_YN
, PRICE_BASIS_YN
, ACCESS_LEVEL
, SERVICE_ITEM_YN
FROM APPS.OKC_LINE_STYLES_V;
|
|
|