FND Design Data [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: ViewAPPS.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