[Home] [Help]
[Dependency Information]
| Object Name: | HXC_PUBLIC_TEMPLATE_LIST_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | HXC.HXC_PUBLIC_TEMPLATE_LIST_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TEMPLATE_ID | NUMBER | (15) | Yes | Public Template Id |
| TEMPLATE_NAME | VARCHAR2 | (150) | Yes | Public Template Name |
| DESCRIPTION | VARCHAR2 | (150) | Public Template Description | |
| DISPLAY_LAYOUT_NAME | VARCHAR2 | (240) | Yes | Display Layout Name |
| RECURRING_PERIOD_NAME | VARCHAR2 | (80) | Yes | Public Template Recurring Period Name |
| RECORDED_HOURS | NUMBER | Recorded Hours | ||
| CREATED_BY_NAME | VARCHAR2 | (240) | Created By | |
| LAST_UPDATE_BY_NAME | VARCHAR2 | (240) | Last Updated By | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group Id |
| START_TIME | DATE | Start Time | ||
| STOP_TIME | DATE | Stop Time |
Cut, paste (and edit) the following text to query this object:
SELECT TEMPLATE_ID
, TEMPLATE_NAME
, DESCRIPTION
, DISPLAY_LAYOUT_NAME
, RECURRING_PERIOD_NAME
, RECORDED_HOURS
, CREATED_BY_NAME
, LAST_UPDATE_BY_NAME
, BUSINESS_GROUP_ID
, START_TIME
, STOP_TIME
FROM APPS.HXC_PUBLIC_TEMPLATE_LIST_V;
APPS
HXC_LAYOUTS_TL
HXC_RECURRING_PERIODS
HXC_TEMPLATE_SUMMARY
PER_ALL_PEOPLE_F
APPS.HXC_PUBLIC_TEMPLATE_LIST_V is not referenced by any database object
|
|
|
|