[Home] [Help]
View: CM_WHSE_SRC_V
Product: | GMF - Process Manufacturing Financials |
Description: | View to enable master-detail relationship on Rollup Source Warehouses form |
Implementation/DBA Data: |
APPS.CM_WHSE_SRC_V
|
View Text
SELECT DISTINCT CWS.LEGAL_ENTITY_ID
, CWS.ORGANIZATION_ID
, CWS.PERIOD_CODE
, CWS.CALENDAR_CODE
, CWS.COST_CATEGORY_ID
, CWS.INVENTORY_ITEM_ID
, CWS.MASTER_ORGANIZATION_ID
, GLE.LEGAL_ENTITY_NAME
FROM CM_WHSE_SRC CWS
, GMF_LEGAL_ENTITIES_VW2 GLE
WHERE GLE.LEGAL_ENTITY_ID = CWS.LEGAL_ENTITY_ID
Columns
Name |
LEGAL_ENTITY_ID |
ORGANIZATION_ID |
PERIOD_CODE |
CALENDAR_CODE |
COST_CATEGORY_ID |
INVENTORY_ITEM_ID |
MASTER_ORGANIZATION_ID |
LEGAL_ENTITY_NAME |