View: PA_ORG_LABOR_SCH_RULE_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_ORG_LABOR_SCH_RULE_V

View Text

SELECT LSR.ROWID
, LSR.ORG_LABOR_SCH_RULE_ID
, LSR.ORGANIZATION_ID
, LSR.ORG_ID
, LSR.LABOR_COSTING_RULE
, LSR.COST_RATE_SCH_ID
, LSR.OVERTIME_PROJECT_ID
, LSR.OVERTIME_TASK_ID
, LSR.ACCT_RATE_DATE_CODE
, LSR.ACCT_RATE_TYPE
, LSR.ACCT_EXCHANGE_RATE
, LSR.START_DATE_ACTIVE
, LSR.END_DATE_ACTIVE
, LSR.CREATION_DATE
, LSR.CREATED_BY
, LSR.LAST_UPDATE_DATE
, LSR.LAST_UPDATED_BY
, LSR.LAST_UPDATE_LOGIN
, SUBSTR(PA_EXPENDITURES_UTILS.GETORGTLNAME(LSR.ORGANIZATION_ID)
, 1
, 80) ORGANIZATION_NAME
, SUBSTR(PA_EXPENDITURES_UTILS.GETORGTLNAME(LSR.ORG_ID)
, 1
, 80) OU_NAME
, SCH.STD_BILL_RATE_SCHEDULE
, PR.SEGMENT1
, PR.NAME
, T.TASK_NAME
, T.TASK_NUMBER
, LSR.FORECAST_COST_RATE_SCH_ID
, SCH1.STD_BILL_RATE_SCHEDULE
, LSR.BASE_HOURS
, LSR.RBC_ELEMENT_TYPE_ID
FROM PA_ORG_LABOR_SCH_RULE LSR
, PA_STD_BILL_RATE_SCHEDULES_ALL SCH
, PA_STD_BILL_RATE_SCHEDULES_ALL SCH1
, PA_PROJECTS_ALL PR
, PA_TASKS T
WHERE LSR.COST_RATE_SCH_ID = SCH.BILL_RATE_SCH_ID(+)
AND LSR.FORECAST_COST_RATE_SCH_ID = SCH1.BILL_RATE_SCH_ID(+)
AND LSR.OVERTIME_PROJECT_ID = PR.PROJECT_ID(+)
AND LSR.OVERTIME_TASK_ID = T.TASK_ID(+)

Columns