DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HXC_APPLICATION_PERIODS_V

Object Details
Object Name: HXC_APPLICATION_PERIODS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewHXC.HXC_APPLICATION_PERIODS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
TIME_BUILDING_BLOCK_ID NUMBER (15) Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
START_TIME DATE

STOP_TIME DATE

TYPE VARCHAR2 (30) Yes
MEASURE NUMBER

UNIT_OF_MEASURE VARCHAR2 (30)
PARENT_BUILDING_BLOCK_ID NUMBER (15)
PARENT_BUILDING_BLOCK_OVN NUMBER (9)
SCOPE VARCHAR2 (30) Yes
APPROVAL_STYLE_ID NUMBER (15)
APPROVAL_STATUS VARCHAR2 (30) Yes
RESOURCE_TYPE VARCHAR2 (30)
RESOURCE_ID NUMBER (15)
COMMENT_TEXT VARCHAR2 (150)
APPLICATION VARCHAR2 (150)
ITEMKEY VARCHAR2 (150)
NOTIFY VARCHAR2 (150)
APPROVER_STATUS VARCHAR2 (150)
SUBMITTED_OVN NUMBER (9) Yes
SUBMISSION_DATE DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TIME_BUILDING_BLOCK_ID
,      OBJECT_VERSION_NUMBER
,      START_TIME
,      STOP_TIME
,      TYPE
,      MEASURE
,      UNIT_OF_MEASURE
,      PARENT_BUILDING_BLOCK_ID
,      PARENT_BUILDING_BLOCK_OVN
,      SCOPE
,      APPROVAL_STYLE_ID
,      APPROVAL_STATUS
,      RESOURCE_TYPE
,      RESOURCE_ID
,      COMMENT_TEXT
,      APPLICATION
,      ITEMKEY
,      NOTIFY
,      APPROVER_STATUS
,      SUBMITTED_OVN
,      SUBMISSION_DATE
FROM APPS.HXC_APPLICATION_PERIODS_V;

Dependencies

[top of page]

APPS.HXC_APPLICATION_PERIODS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHXC_TIME_ATTRIBUTES
SynonymHXC_TIME_ATTRIBUTE_USAGES
SynonymHXC_TIME_BUILDING_BLOCKS
APPS.HXC_APPLICATION_PERIODS_V is referenced by following:

SchemaAPPS
ViewHXC_APPROVAL_DETAILS_V