[Home] [Help] [Dependency Information]
Object Name: | BISFV_TARGET_LEVELS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIS.BISFV_TARGET_LEVELS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
BISFV_TARGET_LEVELS is the full view which duplicates all the columns and expands lookups and foreign keys for the table BIS_TARGET_LEVELS.
Full views are used as a one-stop template for building up ad-hoc queries.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TARGET_LEVEL_ID | NUMBER | Yes | Target Level ID | |
TARGET_LEVEL_SHORT_NAME | VARCHAR2 | (80) | Yes | Target Level Short Name |
TARGET_LEVEL_NAME | VARCHAR2 | (80) | Yes | Target Level Name |
DESCRIPTION | VARCHAR2 | (240) | Description of Target Level | |
MEASURE_ID | NUMBER | Yes | Performance Measure ID | |
DATASET_ID | NUMBER | (5) | Dataset_Id | |
MEASURE_SHORT_NAME | VARCHAR2 | (30) | Yes | Performance Measure Short Name |
MEASURE_NAME | VARCHAR2 | (255) | Yes | Name of Performance Measure |
ORG_LEVEL_ID | NUMBER | No Longer Used | ||
ORG_LEVEL_SHORT_NAME | VARCHAR2 | (30) | No Longer Used | |
ORG_LEVEL_NAME | VARCHAR2 | (4000) | No Longer Used | |
TIME_LEVEL_ID | NUMBER | No Longer Used | ||
TIME_LEVEL_SHORT_NAME | VARCHAR2 | (30) | No Longer Used | |
TIME_LEVEL_NAME | VARCHAR2 | (4000) | No Longer Used | |
DIMENSION1_LEVEL_ID | NUMBER | Dimension Level1 ID | ||
DIMENSION1_LEVEL_SHORT_NAME | VARCHAR2 | (30) | DImension Level1 Short Name | |
DIMENSION1_LEVEL_NAME | VARCHAR2 | (4000) | Dimension Level1 Name | |
DIMENSION2_LEVEL_ID | NUMBER | Dimension Level2 ID | ||
DIMENSION2_LEVEL_SHORT_NAME | VARCHAR2 | (30) | DImension Level2 Short Name | |
DIMENSION2_LEVEL_NAME | VARCHAR2 | (4000) | Dimension Level2 Name | |
DIMENSION3_LEVEL_ID | NUMBER | Dimension Level3 ID | ||
DIMENSION3_LEVEL_SHORT_NAME | VARCHAR2 | (30) | DImension Level3 Short Name | |
DIMENSION3_LEVEL_NAME | VARCHAR2 | (4000) | Dimension Level3 Name | |
DIMENSION4_LEVEL_ID | NUMBER | Dimension Level4 ID | ||
DIMENSION4_LEVEL_SHORT_NAME | VARCHAR2 | (30) | DImension Level4 Short Name | |
DIMENSION4_LEVEL_NAME | VARCHAR2 | (4000) | Dimension Level4 Name | |
DIMENSION5_LEVEL_ID | NUMBER | Dimension Level5 ID | ||
DIMENSION5_LEVEL_SHORT_NAME | VARCHAR2 | (30) | DImension Level5 Short Name | |
DIMENSION5_LEVEL_NAME | VARCHAR2 | (4000) | Dimension Level5 Name | |
DIMENSION6_LEVEL_ID | NUMBER | Dimension Level6 ID | ||
DIMENSION6_LEVEL_SHORT_NAME | VARCHAR2 | (30) | DImension Level6 Short Name | |
DIMENSION6_LEVEL_NAME | VARCHAR2 | (4000) | Dimension Level6 Name | |
DIMENSION7_LEVEL_ID | NUMBER | Dimension Level7 ID | ||
DIMENSION7_LEVEL_SHORT_NAME | VARCHAR2 | (30) | DImension Level7 Short Name | |
DIMENSION7_LEVEL_NAME | VARCHAR2 | (4000) | Dimension Level7 Name | |
WORKFLOW_ITEM_TYPE | VARCHAR2 | (8) | The Workflow type attached to the dimension level combination | |
WORKFLOW_PROCESS_SHORT_NAME | VARCHAR2 | (30) | The Workflow process short name which belongs to the selected workflow item type and is assigned to the dimension level combination | |
WORKFLOW_PROCESS_NAME | VARCHAR2 | (4000) | 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 | |
DEFAULT_NOTIFY_RESP_NAME | VARCHAR2 | (4000) | No Longer Used | |
COMPUTING_FUNCTION_ID | NUMBER | Computing Function ID | ||
COMPUTING_FUNCTION_NAME | VARCHAR2 | (4000) | Computing Function Name | |
COMPUTING_USER_FUNCTION_NAME | VARCHAR2 | (4000) | Computing Function Name | |
REPORT_FUNCTION_ID | NUMBER | No Longer Used | ||
REPORT_FUNCTION_NAME | VARCHAR2 | (4000) | No Longer Used | |
REPORT_USER_FUNCTION_NAME | VARCHAR2 | (4000) | No Longer Used | |
UNIT_OF_MEASURE | VARCHAR2 | (25) | Unit of Measure | |
SYSTEM_FLAG | VARCHAR2 | (1) | No Longer Used | |
SOURCE | VARCHAR2 | (30) | Yes | Source system for the dimension level such as. OLTP, EDW etc. |
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
, DATASET_ID
, MEASURE_SHORT_NAME
, MEASURE_NAME
, ORG_LEVEL_ID
, ORG_LEVEL_SHORT_NAME
, ORG_LEVEL_NAME
, TIME_LEVEL_ID
, TIME_LEVEL_SHORT_NAME
, TIME_LEVEL_NAME
, DIMENSION1_LEVEL_ID
, DIMENSION1_LEVEL_SHORT_NAME
, DIMENSION1_LEVEL_NAME
, DIMENSION2_LEVEL_ID
, DIMENSION2_LEVEL_SHORT_NAME
, DIMENSION2_LEVEL_NAME
, DIMENSION3_LEVEL_ID
, DIMENSION3_LEVEL_SHORT_NAME
, DIMENSION3_LEVEL_NAME
, DIMENSION4_LEVEL_ID
, DIMENSION4_LEVEL_SHORT_NAME
, DIMENSION4_LEVEL_NAME
, DIMENSION5_LEVEL_ID
, DIMENSION5_LEVEL_SHORT_NAME
, DIMENSION5_LEVEL_NAME
, DIMENSION6_LEVEL_ID
, DIMENSION6_LEVEL_SHORT_NAME
, DIMENSION6_LEVEL_NAME
, DIMENSION7_LEVEL_ID
, DIMENSION7_LEVEL_SHORT_NAME
, DIMENSION7_LEVEL_NAME
, WORKFLOW_ITEM_TYPE
, WORKFLOW_PROCESS_SHORT_NAME
, WORKFLOW_PROCESS_NAME
, DEFAULT_NOTIFY_RESP_ID
, DEFAULT_NOTIFY_RESP_SHORT_NAME
, DEFAULT_NOTIFY_RESP_NAME
, COMPUTING_FUNCTION_ID
, COMPUTING_FUNCTION_NAME
, COMPUTING_USER_FUNCTION_NAME
, REPORT_FUNCTION_ID
, REPORT_FUNCTION_NAME
, REPORT_USER_FUNCTION_NAME
, UNIT_OF_MEASURE
, SYSTEM_FLAG
, SOURCE
FROM APPS.BISFV_TARGET_LEVELS;
|
|
|