[Home] [Help] [Dependency Information]
Object Name: | BISBV_TARGET_LEVELS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIS.BISBV_TARGET_LEVELS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
BISBV_TARGET_LEVELS is the business view which provides information about the entity BIS_TARGET_LEVELS.
Business Views are intended to provide a consistent interface for ad-hoc queries by providing simple table joins for over-normalized data and plain english column names for hard to understand columns.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TARGET_LEVEL_ID | NUMBER | Yes | Target Level ID Column | |
TARGET_LEVEL_SHORT_NAME | VARCHAR2 | (80) | Yes | Target Level Short Name |
TARGET_LEVEL_NAME | VARCHAR2 | (80) | Yes | Target Level Name |
DESCRIPTION | VARCHAR2 | (240) | Target Level Description | |
MEASURE_ID | NUMBER | Yes | Measure ID | |
ORG_LEVEL_ID | NUMBER | No Longer Used | ||
TIME_LEVEL_ID | NUMBER | No Longer Used | ||
DIMENSION1_LEVEL_ID | NUMBER | Dimension1 Level ID | ||
DIMENSION2_LEVEL_ID | NUMBER | Dimension2 Level ID | ||
DIMENSION3_LEVEL_ID | NUMBER | Dimension3 Level ID | ||
DIMENSION4_LEVEL_ID | NUMBER | Dimension4 Level ID | ||
DIMENSION5_LEVEL_ID | NUMBER | Dimension5 Level ID | ||
DIMENSION6_LEVEL_ID | NUMBER | Dimension6 Level ID | ||
DIMENSION7_LEVEL_ID | NUMBER | Dimension7 Level ID | ||
WORKFLOW_ITEM_TYPE | VARCHAR2 | (8) | The Workflow type attached to the dimension level combination | |
WORKFLOW_PROCESS_SHORT_NAME | VARCHAR2 | (30) | The Workflow process which belongs to the selected workflow item type and is assigned to the dimension level combination | |
DEFAULT_NOTIFY_RESP_ID | NUMBER | No Longer Used | ||
DEFAULT_NOTIFY_RESP_SHORT_NAME | VARCHAR2 | (100) | No Longer Used | |
COMPUTING_FUNCTION_ID | NUMBER | Computing Function ID | ||
REPORT_FUNCTION_ID | NUMBER | No Longer Used | ||
UNIT_OF_MEASURE | VARCHAR2 | (25) | No Longer Used | |
SYSTEM_FLAG | VARCHAR2 | (1) | No Longer Used |
Cut, paste (and edit) the following text to query this object:
SELECT TARGET_LEVEL_ID
, TARGET_LEVEL_SHORT_NAME
, TARGET_LEVEL_NAME
, DESCRIPTION
, MEASURE_ID
, ORG_LEVEL_ID
, TIME_LEVEL_ID
, DIMENSION1_LEVEL_ID
, DIMENSION2_LEVEL_ID
, DIMENSION3_LEVEL_ID
, DIMENSION4_LEVEL_ID
, DIMENSION5_LEVEL_ID
, DIMENSION6_LEVEL_ID
, DIMENSION7_LEVEL_ID
, WORKFLOW_ITEM_TYPE
, WORKFLOW_PROCESS_SHORT_NAME
, DEFAULT_NOTIFY_RESP_ID
, DEFAULT_NOTIFY_RESP_SHORT_NAME
, COMPUTING_FUNCTION_ID
, REPORT_FUNCTION_ID
, UNIT_OF_MEASURE
, SYSTEM_FLAG
FROM APPS.BISBV_TARGET_LEVELS;
|
|
|