[Home] [Help]
View: PA_CC_TP_BILL_SCH_ORGZN_V
| Product: | PA - Projects |
| Description: | PA_CC_TP_BILL_SCH_ORGZN_V provides bill schedule and organization information within a business group |
| Implementation/DBA Data: |
APPS.PA_CC_TP_BILL_SCH_ORGZN_V
|
View Text
SELECT DISTINCT H.NAME
, B.ORGANIZATION_ID
, B.ORG_ID
, B.SCHEDULE_TYPE
, B.BILL_RATE_SCH_ID
, B.STD_BILL_RATE_SCHEDULE
FROM PA_STD_BILL_RATE_SCHEDULES_ALL B
, HR_ORGANIZATION_UNITS H
WHERE H.ORGANIZATION_ID = B.ORGANIZATION_ID
Columns
| Name |
| NAME |
| ORGANIZATION_ID |
| ORG_ID |
| SCHEDULE_TYPE |
| BILL_RATE_SCH_ID |
| STD_BILL_RATE_SCHEDULE |