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

VIEW: DDR.DDR_E_MFG_SHIP_ITEM#

Object Details
Object Name: DDR_E_MFG_SHIP_ITEM#
Object Type: VIEW
Owner: DDR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REC_ID NUMBER
Yes
LOAD_ID NUMBER
Yes
ERR_REASON VARCHAR2 (500) Yes
BSNS_UNIT_ID NUMBER

BSNS_UNIT_CD VARCHAR2 (30)
SHIP_TO_ORG_CD VARCHAR2 (30)
SHIP_TO_BSNS_UNIT_ID NUMBER

SHIP_TO_BSNS_UNIT_CD VARCHAR2 (30)
DAY_CD VARCHAR2 (30)
MFG_SKU_ITEM_ID NUMBER

MFG_SKU_ITEM_NBR VARCHAR2 (30)
UOM VARCHAR2 (30)
UOM_CD VARCHAR2 (30)
UOM_CD_PRMRY VARCHAR2 (30)
UOM_CD_ALT VARCHAR2 (30)
CRNCY_CD VARCHAR2 (30)
SHIP_QTY NUMBER

SHIP_QTY_PRMRY NUMBER

SHIP_QTY_ALT NUMBER

SHIP_AMT NUMBER

SHIP_AMT_LCL NUMBER

SHIP_COST NUMBER

SHIP_COST_LCL NUMBER

TRANS_DT DATE

SRC_SYS_IDNT VARCHAR2 (40) Yes
SRC_SYS_DT DATE
Yes
SRC_IDNT_FLAG VARCHAR2 (1)
ACTION_FLAG VARCHAR2 (1)
Query Text

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


SELECT REC_ID
,      LOAD_ID
,      ERR_REASON
,      BSNS_UNIT_ID
,      BSNS_UNIT_CD
,      SHIP_TO_ORG_CD
,      SHIP_TO_BSNS_UNIT_ID
,      SHIP_TO_BSNS_UNIT_CD
,      DAY_CD
,      MFG_SKU_ITEM_ID
,      MFG_SKU_ITEM_NBR
,      UOM
,      UOM_CD
,      UOM_CD_PRMRY
,      UOM_CD_ALT
,      CRNCY_CD
,      SHIP_QTY
,      SHIP_QTY_PRMRY
,      SHIP_QTY_ALT
,      SHIP_AMT
,      SHIP_AMT_LCL
,      SHIP_COST
,      SHIP_COST_LCL
,      TRANS_DT
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      SRC_IDNT_FLAG
,      ACTION_FLAG
FROM DDR.DDR_E_MFG_SHIP_ITEM#;

Dependencies

[top of page]

DDR.DDR_E_MFG_SHIP_ITEM# references the following:

SchemaDDR
TableDDR_E_MFG_SHIP_ITEM
DDR.DDR_E_MFG_SHIP_ITEM# is referenced by following:

SchemaAPPS
SynonymDDR_E_MFG_SHIP_ITEM