[Home] [Help]
[Dependency Information]
VIEW: WIP.WIP_EMPLOYEE_LABOR_RATES_EFC#
Object Details
Object Name: | WIP_EMPLOYEE_LABOR_RATES_EFC# |
Object Type: | VIEW |
Owner: | WIP |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ORGANIZATION_ID |
NUMBER |
|
Yes |
|
EMPLOYEE_ID |
NUMBER |
|
Yes |
|
HOURLY_LABOR_RATE |
NUMBER |
|
Yes |
|
EFFECTIVE_DATE |
DATE |
|
Yes |
|
SET_OF_BOOKS_ID |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, EMPLOYEE_ID
, HOURLY_LABOR_RATE
, EFFECTIVE_DATE
, SET_OF_BOOKS_ID
FROM WIP.WIP_EMPLOYEE_LABOR_RATES_EFC#;
Dependencies
[top of page]
WIP.WIP_EMPLOYEE_LABOR_RATES_EFC# references the following:
-
WIP
-
WIP_EMPLOYEE_LABOR_RATES_EFC
WIP.WIP_EMPLOYEE_LABOR_RATES_EFC# is referenced by following:
-
APPS
-
WIP_EMPLOYEE_LABOR_RATES_EFC