Skip to content

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

VIEW: HXC.HXC_RET_PA_LATEST_DETAILS#

Object Details
Object Name: HXC_RET_PA_LATEST_DETAILS#
Object Type: VIEW
Owner: HXC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (15) Yes
TIME_BUILDING_BLOCK_ID NUMBER (15) Yes
APPROVAL_STATUS VARCHAR2 (30) Yes
START_TIME DATE
Yes
STOP_TIME DATE
Yes
ORG_ID NUMBER (15)
BUSINESS_GROUP_ID NUMBER (15)
TIMECARD_ID NUMBER (15)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
MEASURE NUMBER

OBJECT_VERSION_NUMBER NUMBER (9) Yes
OLD_OVN NUMBER (9)
OLD_MEASURE NUMBER

OLD_ATTRIBUTE1 VARCHAR2 (240)
OLD_ATTRIBUTE2 VARCHAR2 (240)
OLD_ATTRIBUTE3 VARCHAR2 (240)
PEI_ID NUMBER

RETRO_PEI_ID NUMBER

OLD_PEI_ID NUMBER

REQUEST_ID NUMBER

RETRO_EXP_GROUP VARCHAR2 (400)
EXP_GROUP VARCHAR2 (400)
OLD_REQUEST_ID NUMBER (15)
OLD_EXP_GROUP VARCHAR2 (400)
Query Text

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


SELECT RESOURCE_ID
,      TIME_BUILDING_BLOCK_ID
,      APPROVAL_STATUS
,      START_TIME
,      STOP_TIME
,      ORG_ID
,      BUSINESS_GROUP_ID
,      TIMECARD_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      MEASURE
,      OBJECT_VERSION_NUMBER
,      OLD_OVN
,      OLD_MEASURE
,      OLD_ATTRIBUTE1
,      OLD_ATTRIBUTE2
,      OLD_ATTRIBUTE3
,      PEI_ID
,      RETRO_PEI_ID
,      OLD_PEI_ID
,      REQUEST_ID
,      RETRO_EXP_GROUP
,      EXP_GROUP
,      OLD_REQUEST_ID
,      OLD_EXP_GROUP
FROM HXC.HXC_RET_PA_LATEST_DETAILS#;

Dependencies

[top of page]

HXC.HXC_RET_PA_LATEST_DETAILS# references the following:

SchemaHXC
TableHXC_RET_PA_LATEST_DETAILS
HXC.HXC_RET_PA_LATEST_DETAILS# is referenced by following:

SchemaAPPS
SynonymHXC_RET_PA_LATEST_DETAILS