[Home] [Help] [Dependency Information]
Object Name: | OKS_USAGE_ITEM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKS.OKS_USAGE_ITEM_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (40) | Name | |
SOURCE_DETAILS | VARCHAR2 | (693) | Source Details | |
DESCRIPTION | VARCHAR2 | (240) | Description | |
UOM_CODE | VARCHAR2 | (3) | Uom Code | |
ID1 | NUMBER | Id1 | ||
ID2 | CHAR | (1) | ||
OBJECT_CODE | CHAR | (11) | Object Code | |
SOURCE_ID | NUMBER | Source Id | ||
COUNTER_GROUP_ID | NUMBER | Counter Group Id | ||
TEMPLATE_COUNTER_GROUP_ID | NUMBER | Template Counter Group Id | ||
COUNTER | VARCHAR2 | (80) | Counter | |
USAGE_ITEM_ID | NUMBER | Usage Item Id | ||
PARTY_ID | NUMBER | Party Id | ||
REC_TYPE | VARCHAR2 | (5) | Rec Type | |
START_DATE_ACTIVE | DATE | Start Date Active | ||
END_DATE_ACTIVE | DATE | End Date Active | ||
SOURCE_OBJECT_CODE | VARCHAR2 | (30) | Source Object Code | |
INSTANCE_NUMBER | VARCHAR2 | (30) | Instance Number | |
SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number | |
EXTERNAL_REFERENCE | VARCHAR2 | (30) | External Reference |
Cut, paste (and edit) the following text to query this object:
SELECT NAME
, SOURCE_DETAILS
, DESCRIPTION
, UOM_CODE
, ID1
, ID2
, OBJECT_CODE
, SOURCE_ID
, COUNTER_GROUP_ID
, TEMPLATE_COUNTER_GROUP_ID
, COUNTER
, USAGE_ITEM_ID
, PARTY_ID
, REC_TYPE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, SOURCE_OBJECT_CODE
, INSTANCE_NUMBER
, SERIAL_NUMBER
, EXTERNAL_REFERENCE
FROM APPS.OKS_USAGE_ITEM_V;
APPS.OKS_USAGE_ITEM_V is not referenced by any database object
|
|
|