DBA Data[Home] [Help]

VIEW: APPS.PA_ORGANIZATIONS_SBRS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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