[Home] [Help]
View: PA_ORGANIZATIONS_SBRS_V
View Text
SELECT BRS.ORGANIZATION_ID
, BRS.SCHEDULE_TYPE
, BRS.BILL_RATE_SCH_ID
, BRS.STD_BILL_RATE_SCHEDULE
, BRS.RATE_SCH_CURRENCY_CODE
, BRS.SHARE_ACROSS_OU_FLAG
, O.NAME
, O.BUSINESS_GROUP_ID
, O.DATE_FROM
, O.DATE_TO
, BRS.ORG_ID
FROM HR_ORGANIZATION_UNITS O
, PA_STD_BILL_RATE_SCHEDULES_ALL BRS
WHERE O.ORGANIZATION_ID = BRS.ORGANIZATION_ID
Columns
Name |
ORGANIZATION_ID |
SCHEDULE_TYPE |
BILL_RATE_SCH_ID |
STD_BILL_RATE_SCHEDULE |
RATE_SCH_CURRENCY_CODE |
SHARE_ACROSS_OU_FLAG |
NAME |
BUSINESS_GROUP_ID |
DATE_FROM |
DATE_TO |
ORG_ID |