1. Tables and Views for Project Management
  2. PJF_JOB_RATES_V

PJF_JOB_RATES_V

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

RATE_SCHEDULE_ID

JOB_SET_ID

SET_ID

CURRENCY_CODE

SCHEDULE_LINE_ID

JOB_ID

RATE

RATE_UNIT

START_DATE_ACTIVE

END_DATE_ACTIVE

Query

SQL_Statement

SELECT

RS.RATE_SCHEDULE_ID,

RS.JOB_SET_ID,

RS.SET_ID,

RS.CURRENCY_CODE,

RSL.SCHEDULE_LINE_ID,

RSL.JOB_ID,

RSL.RATE,

RSL.RATE_UNIT,

RSL.START_DATE_ACTIVE,

RSL.END_DATE_ACTIVE

FROM

PJF_RATE_SCHEDULES_B RS,

PJF_RATE_SCHEDULE_LINES RSL

WHERE

RS.RATE_SCHEDULE_ID = RSL.RATE_SCHEDULE_ID(+) AND RS.SCHEDULE_TYPE = 'JOB'