View: CM_RSRC_DTL_V

Product:	GMF - Process Manufacturing Financials
Description:	View to enable master-detail relationship on Resource Costs form
Implementation/DBA Data:	APPS.CM_RSRC_DTL_V

View Text

SELECT DISTINCT R.ORGANIZATION_ID
, R.RESOURCES
, P.CALENDAR_CODE
, P.PERIOD_CODE
, R.LEGAL_ENTITY_ID
, L.LEGAL_ENTITY_NAME
FROM CM_RSRC_DTL R
, GMF_PERIOD_STATUSES P
, GMF_LEGAL_ENTITIES_VW2 L
WHERE R.PERIOD_ID = P.PERIOD_ID
AND L.LEGAL_ENTITY_ID = R.LEGAL_ENTITY_ID

Columns