[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 |
APPS.PA_ORGANIZATIONS_SBRS_V