[Home] [Help]
[Dependency Information]
| Object Name: | CSD_RETURNS_BI_POM_MV |
|---|---|
| Object Type: | TABLE |
| Owner: | APPS |
| FND Design Data: | CSD.CSD_RETURNS_BI_POM_MV
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: | APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| 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) |
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;
APPS.CSD_RETURNS_BI_POM_MV does not reference any database object
APPS.CSD_RETURNS_BI_POM_MV is referenced by following:
APPS
CSD_RETURNS_BI_POM_MV
|
|
|
|