[Home] [Help] [Dependency Information]
Object Name: | HXTFV_PROJECT_ACCOUNTING |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | HXT.HXTFV_PROJECT_ACCOUNTING |
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 |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | Business Group of person |
PERSON_NAME | VARCHAR2 | (240) | Name of person | |
PROJECT_NAME | VARCHAR2 | (80) | Yes | Project or work order title |
PROJECT_NUMBER | VARCHAR2 | (10) | Yes | Project / Work Order number |
PROJECT_DESCRIPTION | VARCHAR2 | (255) | Project or work order description | |
PROJECT_START | DATE | Yes | Date Project/Work Order becomes effective | |
PROJECT_END | DATE | Date Project/Work Order ceases to be effective | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Person's organization name |
TASK_NAME | VARCHAR2 | (80) | Yes | Task name |
TASK_DESCRIPTION | VARCHAR2 | (255) | Task description | |
TASK_ESTIMATED_TIME | NUMBER | (8) | Estimated duration of task units | |
TASK_UNITS | VARCHAR2 | (4000) | Task duration unit | |
TASK_NUMBER | VARCHAR2 | (25) | Task number | |
TASK_START | DATE | Yes | Date Project Task becomes effective | |
TASK_END | DATE | Date Project Task ceases to be effective | ||
DATE_WORKED | DATE | Yes | The date the hours were worked or absence was taken | |
HOURS | NUMBER | (7) | Yes | Number of hours worked or absent |
TIME_IN | DATE | Time work started | ||
TIME_OUT | DATE | Time work ended | ||
HRW_COMMENT | VARCHAR2 | (255) | Comment on time worked | |
RATE_MULTIPLE | NUMBER | (15) | Rate multiple factor | |
HOURLY_RATE | NUMBER | (15) | Hourly Rate | |
AMOUNT | NUMBER | (15) | Amount | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
DET_HOURS_WORKED_ID | NUMBER | (15) | Yes | |
EARNING_POLICY_ID | NUMBER | (15) | ||
ELEMENT_TYPE_ID | NUMBER | (9) | ||
JOB_ID | NUMBER | (15) | ||
LOCATION_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | Yes | |
PERSON_ID | NUMBER | (10) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
SHIFT_ID | NUMBER | (15) | ||
SUM_HOURS_WORKED_ID | NUMBER | (15) | Yes | |
TASK_ID | NUMBER | (15) | Yes | |
TIMECARD_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, PERSON_NAME
, PROJECT_NAME
, PROJECT_NUMBER
, PROJECT_DESCRIPTION
, PROJECT_START
, PROJECT_END
, ORGANIZATION_NAME
, TASK_NAME
, TASK_DESCRIPTION
, TASK_ESTIMATED_TIME
, TASK_UNITS
, TASK_NUMBER
, TASK_START
, TASK_END
, DATE_WORKED
, HOURS
, TIME_IN
, TIME_OUT
, HRW_COMMENT
, RATE_MULTIPLE
, HOURLY_RATE
, AMOUNT
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
, DET_HOURS_WORKED_ID
, EARNING_POLICY_ID
, ELEMENT_TYPE_ID
, JOB_ID
, LOCATION_ID
, ORGANIZATION_ID
, PERSON_ID
, PROJECT_ID
, SHIFT_ID
, SUM_HOURS_WORKED_ID
, TASK_ID
, TIMECARD_ID
FROM APPS.HXTFV_PROJECT_ACCOUNTING;
APPS.HXTFV_PROJECT_ACCOUNTING is not referenced by any database object
|
|
|