DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CM_WHSE_SRC_V

Object Details
Object Name: CM_WHSE_SRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMF.CM_WHSE_SRC_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View to enable master-detail relationship on Rollup Source Warehouses form


[View Source]

Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity Id
ORGANIZATION_ID NUMBER (15)
organization identifier
PERIOD_CODE VARCHAR2 (10)
period code
CALENDAR_CODE VARCHAR2 (10)
calendar code
COST_CATEGORY_ID NUMBER

cost category identifier
INVENTORY_ITEM_ID NUMBER (15)
inventory item identifier
MASTER_ORGANIZATION_ID NUMBER (15)
master organization identifier
LEGAL_ENTITY_NAME VARCHAR2 (240) Yes Legal Entity Name
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LEGAL_ENTITY_ID
,      ORGANIZATION_ID
,      PERIOD_CODE
,      CALENDAR_CODE
,      COST_CATEGORY_ID
,      INVENTORY_ITEM_ID
,      MASTER_ORGANIZATION_ID
,      LEGAL_ENTITY_NAME
FROM APPS.CM_WHSE_SRC_V;

Dependencies

[top of page]

APPS.CM_WHSE_SRC_V references the following:

SchemaAPPS
SynonymCM_WHSE_SRC
ViewGMF_LEGAL_ENTITIES_VW2

APPS.CM_WHSE_SRC_V is not referenced by any database object