eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GMF_RESOURCE_COSTS_V

Source

View Text - Preformatted


SELECT rsrc.resources, rsrc.usage_uom, rsrc.cost_type_id, rsrc.period_id, rsrc.organization_id, rsrc.organization_code, rsrc.calendar_code, rsrc.period_code, nvl(rsrc.orgs_ncost, rsrc.global_ncost) nominal_cost FROM ( SELECT rsrc.resources, rsrc.usage_uom, rsrc.cost_type_id, rsrc.period_id, gpo.organization_id, gpo.organization_code, rsrc.calendar_code, rsrc.period_code, CASE WHEN rsrc.organization_id IS NOT NULL THEN nominal_cost ELSE null END orgs_ncost, CASE WHEN rsrc.organization_id IS NULL THEN nominal_cost ELSE null END global_ncost, row_number() over ( partition by rsrc.resources, rsrc.cost_type_id, rsrc.period_id, nvl(rsrc.organization_id, gpo.organization_id) order by rsrc.resources, rsrc.cost_type_id, rsrc.period_id, rsrc.organization_id NULLS LAST ) row_rank FROM ( SELECT rsrc.resources, rsrc.usage_uom, rsrc.period_id, rsrc.organization_id, rsrc.cost_type_id, rsrc.calendar_code, rsrc.period_code, nominal_cost FROM cm_rsrc_dtl rsrc, ( SELECT legal_entity_id FROM gmf_process_organizations_gt WHERE ROWNUM = 1 ) gpo WHERE rsrc.legal_entity_id + (0*gpo.legal_entity_id) = gpo.legal_entity_id and rsrc.delete_mark = 0 ) rsrc, gmf_process_organizations_gt gpo WHERE nvl(rsrc.organization_id, gpo.organization_id) = gpo.organization_id ) rsrc WHERE row_rank = 1

View Text - HTML Formatted

SELECT RSRC.RESOURCES
, RSRC.USAGE_UOM
, RSRC.COST_TYPE_ID
, RSRC.PERIOD_ID
, RSRC.ORGANIZATION_ID
, RSRC.ORGANIZATION_CODE
, RSRC.CALENDAR_CODE
, RSRC.PERIOD_CODE
, NVL(RSRC.ORGS_NCOST
, RSRC.GLOBAL_NCOST) NOMINAL_COST
FROM ( SELECT RSRC.RESOURCES
, RSRC.USAGE_UOM
, RSRC.COST_TYPE_ID
, RSRC.PERIOD_ID
, GPO.ORGANIZATION_ID
, GPO.ORGANIZATION_CODE
, RSRC.CALENDAR_CODE
, RSRC.PERIOD_CODE
, CASE WHEN RSRC.ORGANIZATION_ID IS NOT NULL THEN NOMINAL_COST ELSE NULL END ORGS_NCOST
, CASE WHEN RSRC.ORGANIZATION_ID IS NULL THEN NOMINAL_COST ELSE NULL END GLOBAL_NCOST
, ROW_NUMBER() OVER ( PARTITION BY RSRC.RESOURCES
, RSRC.COST_TYPE_ID
, RSRC.PERIOD_ID
, NVL(RSRC.ORGANIZATION_ID
, GPO.ORGANIZATION_ID) ORDER BY RSRC.RESOURCES
, RSRC.COST_TYPE_ID
, RSRC.PERIOD_ID
, RSRC.ORGANIZATION_ID NULLS LAST ) ROW_RANK
FROM ( SELECT RSRC.RESOURCES
, RSRC.USAGE_UOM
, RSRC.PERIOD_ID
, RSRC.ORGANIZATION_ID
, RSRC.COST_TYPE_ID
, RSRC.CALENDAR_CODE
, RSRC.PERIOD_CODE
, NOMINAL_COST
FROM CM_RSRC_DTL RSRC
, ( SELECT LEGAL_ENTITY_ID
FROM GMF_PROCESS_ORGANIZATIONS_GT
WHERE ROWNUM = 1 ) GPO
WHERE RSRC.LEGAL_ENTITY_ID + (0*GPO.LEGAL_ENTITY_ID) = GPO.LEGAL_ENTITY_ID
AND RSRC.DELETE_MARK = 0 ) RSRC
, GMF_PROCESS_ORGANIZATIONS_GT GPO
WHERE NVL(RSRC.ORGANIZATION_ID
, GPO.ORGANIZATION_ID) = GPO.ORGANIZATION_ID ) RSRC
WHERE ROW_RANK = 1