[Home] [Help]
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
Name |
RESOURCES |
USAGE_UOM |
COST_TYPE_ID |
PERIOD_ID |
ORGANIZATION_ID |
ORGANIZATION_CODE |
CALENDAR_CODE |
PERIOD_CODE |
NOMINAL_COST |