[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 |