[Home] [Help]
[Dependency Information]
[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
BIS_BUCKET_CUSTOMIZATIONS
BIS_BUCKET_CUSTOMIZATIONS_TL
BIS_BUCKET_TL
APPS.BIS_BUCKET_CUSTOMIZATIONS_VL is not referenced by any database object
|
|
|
|