CST_RESOURCE_RATES_VCP_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
ORGANIZATION_ID RESOURCE_ID RESOURCE_CODE UOM_CODE TOTAL_RATE CURRENCY_CODE

Query

SQL_Statement

SELECT wr.organization_id, wr.resource_id, wr.resource_code, wr.uom_code, SUM(csrrd.unit_rate) total_rate, csrr.currency_code FROM cst_std_resource_rates csrr, cst_std_resource_rate_details csrrd, cst_cost_org_books ccob, wis_resources_vl wr WHERE csrr.std_resource_rate_id = csrrd.std_resource_rate_id AND csrr.inv_org_id = wr.organization_id AND ccob.cost_org_id = csrr.cost_org_id AND ccob.cost_book_id = csrr.cost_book_id AND wr.organization_id = csrr.inv_org_id AND wr.resource_id = csrr.resource_id AND csrr.status_code = 'PUBLISHED' AND ccob.primary_book_flag = 'Y' AND SYSDATE BETWEEN csrr.effective_start_date AND csrr.effective_end_date GROUP BY wr.organization_id, wr.resource_id, wr.resource_code, wr.uom_code, csrr.currency_code