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


TABLE: APPS.CSD_RETURNS_BI_POM_MV

Object Details
Object Name: CSD_RETURNS_BI_POM_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableCSD.CSD_RETURNS_BI_POM_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
OPERATING_UNIT_ID NUMBER

INVENTORY_ORG_ID NUMBER

INVENTORY_ITEM_ID NUMBER

TOTAL_QUANTITY NUMBER

PRIMARY_UOM_CODE VARCHAR2 (3)
TRANSACTION_DATE DATE

TOTAL_WEIGHT NUMBER

WEIGHT_UOM_CODE VARCHAR2 (3)
CATEGORY_ID NUMBER

CATEGORY_SET_ID NUMBER

SHIP_GEOGRAPHY_TYPE VARCHAR2 (30)
SHIP_GEOGRAPHY_ID NUMBER

CUSTOMER_TYPE VARCHAR2 (30)
Query Text

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


SELECT OPERATING_UNIT_ID
,      INVENTORY_ORG_ID
,      INVENTORY_ITEM_ID
,      TOTAL_QUANTITY
,      PRIMARY_UOM_CODE
,      TRANSACTION_DATE
,      TOTAL_WEIGHT
,      WEIGHT_UOM_CODE
,      CATEGORY_ID
,      CATEGORY_SET_ID
,      SHIP_GEOGRAPHY_TYPE
,      SHIP_GEOGRAPHY_ID
,      CUSTOMER_TYPE
FROM APPS.CSD_RETURNS_BI_POM_MV;

Dependencies

[top of page]

APPS.CSD_RETURNS_BI_POM_MV does not reference any database object

APPS.CSD_RETURNS_BI_POM_MV is referenced by following:

SchemaAPPS
Materialized ViewCSD_RETURNS_BI_POM_MV