[Home] [Help]
View: CM_CMPT_MTL_V
Product: | GMF - Process Manufacturing Financials |
Description: | View to enable master-detail relationship on Material Cost Components form |
Implementation/DBA Data: |
APPS.CM_CMPT_MTL_V
|
View Text
SELECT DISTINCT CCM.LEGAL_ENTITY_ID
, CCM.COST_CATEGORY_ID
, CCM.INVENTORY_ITEM_ID
, CCM.ORGANIZATION_ID
, CCM.MASTER_ORGANIZATION_ID
, GLE.LEGAL_ENTITY_NAME
FROM CM_CMPT_MTL CCM
, GMF_LEGAL_ENTITIES_VW2 GLE
WHERE GLE.LEGAL_ENTITY_ID = CCM.LEGAL_ENTITY_ID
Columns
Name |
LEGAL_ENTITY_ID |
COST_CATEGORY_ID |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
MASTER_ORGANIZATION_ID |
LEGAL_ENTITY_NAME |