1. Tables and Views for Project Management
  2. PJF_NON_LABOR_RATES_V

PJF_NON_LABOR_RATES_V

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

RATE_SCHEDULE_ID

SET_ID

CURRENCY_CODE

SCHEDULE_LINE_ID

EXPENDITURE_TYPE_ID

NL_RES_ORGANIZATION_ID

NON_LABOR_RESOURCE_ID

RATE

RATE_UNIT

MARKUP_PERCENTAGE

START_DATE_ACTIVE

END_DATE_ACTIVE

Query

SQL_Statement

SELECT RS.RATE_SCHEDULE_ID,

RS.SET_ID,

RS.CURRENCY_CODE,

RSL.SCHEDULE_LINE_ID,

RSL.EXPENDITURE_TYPE_ID,

RSL.NL_RES_ORGANIZATION_ID,

RSL.NON_LABOR_RESOURCE_ID,

RSL.RATE,

RSL.RATE_UNIT,

RSL.MARKUP_PERCENTAGE,

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 = 'NON-LABOR'