[Home] [Help] [Dependency Information]
Object Name: | CAC_SR_PERIODS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.CAC_SR_PERIODS_VL
JTF.CAC_SR_PERIODS_VL |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view contains describing attributes for a period.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Id | |
PERIOD_ID | NUMBER | Yes | Unique Id for Period | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object Version Number | |
PERIOD_CATEGORY_ID | NUMBER | Yes | Category Id of a period (foreign key to CAC_SR_PERIOD_CATS_B.PERIOD_CATEGORY_ID) | |
START_DATE_ACTIVE | DATE | Start Date Active | ||
END_DATE_ACTIVE | DATE | End Date Active | ||
SHOW_IN_LOV | VARCHAR2 | (1) | Yes | Show in LOV |
WEEK_DAY_NUM | NUMBER | Week Day Number | ||
START_TIME_MS | NUMBER | Start Time of period | ||
END_TIME_MS | NUMBER | End Time of period | ||
DURATION | NUMBER | Duration of period | ||
DURATION_UOM | VARCHAR2 | (30) | Unit of measure for duration | |
SHORT_CODE | VARCHAR2 | (3) | Short Code for Period | |
HAS_DETAILS | VARCHAR2 | (1) | Flag to indicate whether period details are present or not | |
PERIOD_NAME | VARCHAR2 | (2000) | Name of the period | |
PERIOD_DESC | VARCHAR2 | (2000) | Description of the period | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID) | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID) | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PERIOD_ID
, OBJECT_VERSION_NUMBER
, PERIOD_CATEGORY_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, SHOW_IN_LOV
, WEEK_DAY_NUM
, START_TIME_MS
, END_TIME_MS
, DURATION
, DURATION_UOM
, SHORT_CODE
, HAS_DETAILS
, PERIOD_NAME
, PERIOD_DESC
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.CAC_SR_PERIODS_VL;
|
|
|