[Home] [Help] [Dependency Information]
Object Name: | DDR_DMNTRA_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SDATE | DATE | |||
LEVEL1 | VARCHAR2 | (30) | ||
LEVEL2 | VARCHAR2 | (30) | ||
SHIP_QTY_POS | NUMBER | |||
ORDR_QTY_POS | NUMBER | |||
SLS_QTY_POS | NUMBER | |||
FRCST_SLS_QTY_POS | NUMBER | |||
FRCST_SLS_QTY_DC | NUMBER | |||
ON_HAND_QTY_DC | NUMBER | |||
ON_HAND_QTY_POS | NUMBER | |||
IN_TRANSIT_QTY_DC | NUMBER | |||
MFG_ORG_CD | VARCHAR2 | (30) | ||
MFG_SKU_ITEM_NBR | VARCHAR2 | (30) | ||
MFG_ITEM_EXT_ID | VARCHAR2 | (240) | ||
MFG_ORG_CD_1 | VARCHAR2 | (30) | ||
ORG_CD | VARCHAR2 | (30) | ||
BSNS_UNIT_CD | VARCHAR2 | (30) | ||
MFG_LOC_EXT_ID | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT SDATE
, LEVEL1
, LEVEL2
, SHIP_QTY_POS
, ORDR_QTY_POS
, SLS_QTY_POS
, FRCST_SLS_QTY_POS
, FRCST_SLS_QTY_DC
, ON_HAND_QTY_DC
, ON_HAND_QTY_POS
, IN_TRANSIT_QTY_DC
, MFG_ORG_CD
, MFG_SKU_ITEM_NBR
, MFG_ITEM_EXT_ID
, MFG_ORG_CD_1
, ORG_CD
, BSNS_UNIT_CD
, MFG_LOC_EXT_ID
FROM APPS.DDR_DMNTRA_V;
APPS.DDR_DMNTRA_V is not referenced by any database object
|
|
|