View: GMF_RESOURCE_COSTS_V

Product:	GMF - Process Manufacturing Financials
Description:	Resource Costs View
Implementation/DBA Data:	APPS.GMF_RESOURCE_COSTS_V

View Text

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

Columns