[Home] [Help] [Dependency Information]
Object Name: | BIS_BUCKET_CUSTOMIZATIONS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIS.BIS_BUCKET_CUSTOMIZATIONS_VL |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View contains customized data for buckets.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Id | |
BUCKET_ID | NUMBER | Yes | Bucket Id | |
USER_ID | NUMBER | User Id | ||
RESPONSIBILITY_ID | NUMBER | Responsibility Id | ||
ORG_ID | NUMBER | Org Id | ||
APPLICATION_ID | NUMBER | Application Id | ||
SITE_ID | NUMBER | Site Id | ||
PAGE_ID | NUMBER | Page Id | ||
FUNCTION_ID | NUMBER | Function Id | ||
RANGE1_LOW | NUMBER | Range1 Low | ||
RANGE1_HIGH | NUMBER | Range1 High | ||
RANGE2_LOW | NUMBER | Range2 Low | ||
RANGE2_HIGH | NUMBER | Range2 High | ||
RANGE3_LOW | NUMBER | Range3 Low | ||
RANGE3_HIGH | NUMBER | Range3 High | ||
RANGE4_LOW | NUMBER | Range4 Low | ||
RANGE4_HIGH | NUMBER | Range4 High | ||
RANGE5_LOW | NUMBER | Range5 Low | ||
RANGE5_HIGH | NUMBER | Range5 High | ||
RANGE6_LOW | NUMBER | Range6 Low | ||
RANGE6_HIGH | NUMBER | Range6 High | ||
RANGE7_LOW | NUMBER | Range7 Low | ||
RANGE7_HIGH | NUMBER | Range7 High | ||
RANGE8_LOW | NUMBER | Range8 Low | ||
RANGE8_HIGH | NUMBER | Range8 High | ||
RANGE9_LOW | NUMBER | Range9 Low | ||
RANGE9_HIGH | NUMBER | Range9 High | ||
RANGE10_LOW | NUMBER | Range10 Low | ||
RANGE10_HIGH | NUMBER | Range10 High | ||
CREATION_DATE | DATE | Yes | Creation Date | |
CREATED_BY | NUMBER | Yes | Created By | |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date | |
LAST_UPDATED_BY | NUMBER | Yes | Last Update By | |
LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
RANGE1_NAME | VARCHAR2 | (80) | Range1 Name | |
RANGE2_NAME | VARCHAR2 | (80) | Range2 Name | |
RANGE3_NAME | VARCHAR2 | (80) | Range3 Name | |
RANGE4_NAME | VARCHAR2 | (80) | Range4 Name | |
RANGE5_NAME | VARCHAR2 | (80) | Range5 Name | |
RANGE6_NAME | VARCHAR2 | (80) | Range6 Name | |
RANGE7_NAME | VARCHAR2 | (80) | Range7 Name | |
RANGE8_NAME | VARCHAR2 | (80) | Range8 Name | |
RANGE9_NAME | VARCHAR2 | (80) | Range9 Name | |
RANGE10_NAME | VARCHAR2 | (80) | Range10 Name | |
CUSTOMIZED | VARCHAR2 | (1) | Customized Flag | |
SHORT_NAME | VARCHAR2 | (30) | Yes | Short name of bucket |
TYPE | VARCHAR2 | (30) | Yes | Type of Bucket |
UPDATABLE | VARCHAR2 | (1) | UPDATABLE(T/F) | |
EXPANDABLE | VARCHAR2 | (1) | EXPANDABLE(T/F) | |
DISCONTINUOUS | VARCHAR2 | (1) | DISCONTINUOUS(T/F) | |
OVERLAPPING | VARCHAR2 | (1) | OVERLAPPING(T/F) | |
UOM | VARCHAR2 | (10) | Unit of Measure | |
NAME | VARCHAR2 | (80) | Yes | Bucket Name |
DESCRIPTION | VARCHAR2 | (240) | Bucket Description |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, BUCKET_ID
, USER_ID
, RESPONSIBILITY_ID
, ORG_ID
, APPLICATION_ID
, SITE_ID
, PAGE_ID
, FUNCTION_ID
, RANGE1_LOW
, RANGE1_HIGH
, RANGE2_LOW
, RANGE2_HIGH
, RANGE3_LOW
, RANGE3_HIGH
, RANGE4_LOW
, RANGE4_HIGH
, RANGE5_LOW
, RANGE5_HIGH
, RANGE6_LOW
, RANGE6_HIGH
, RANGE7_LOW
, RANGE7_HIGH
, RANGE8_LOW
, RANGE8_HIGH
, RANGE9_LOW
, RANGE9_HIGH
, RANGE10_LOW
, RANGE10_HIGH
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, RANGE1_NAME
, RANGE2_NAME
, RANGE3_NAME
, RANGE4_NAME
, RANGE5_NAME
, RANGE6_NAME
, RANGE7_NAME
, RANGE8_NAME
, RANGE9_NAME
, RANGE10_NAME
, CUSTOMIZED
, SHORT_NAME
, TYPE
, UPDATABLE
, EXPANDABLE
, DISCONTINUOUS
, OVERLAPPING
, UOM
, NAME
, DESCRIPTION
FROM APPS.BIS_BUCKET_CUSTOMIZATIONS_VL;
APPS.BIS_BUCKET_CUSTOMIZATIONS_VL is not referenced by any database object
|
|
|