Skip to content

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

VIEW: DDR.DDR_B_RTL_ORDR_ITEM_DAY#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30) Yes
RTL_ORG_CD VARCHAR2 (30) Yes
ORG_BSNS_UNIT_ID NUMBER
Yes
RTL_BSNS_UNIT_CD VARCHAR2 (30)
DAY_CD VARCHAR2 (30) Yes
GLBL_ITEM_ID VARCHAR2 (30) Yes
RTL_SKU_ITEM_ID NUMBER
Yes
RTL_SKU_ITEM_NBR VARCHAR2 (30) Yes
GLBL_ITEM_ID_TYP VARCHAR2 (30)
UOM_CD VARCHAR2 (30)
UOM_CD_PRMRY VARCHAR2 (30)
UOM_CD_ALT VARCHAR2 (30)
CRNCY_CD VARCHAR2 (30)
ORDR_QTY NUMBER

ORDR_QTY_PRMRY NUMBER

ORDR_QTY_ALT NUMBER

ORDR_AMT NUMBER

ORDR_AMT_LCL NUMBER

ORDR_AMT_RPT NUMBER

SRC_SYS_IDNT VARCHAR2 (40) Yes
SRC_SYS_DT DATE
Yes
CRTD_BY_DSR VARCHAR2 (30) Yes
LAST_UPDT_BY_DSR VARCHAR2 (30) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
MFG_SKU_ITEM_ID NUMBER

ITM_TYP VARCHAR2 (1)
Query Text

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


SELECT MFG_ORG_CD
,      RTL_ORG_CD
,      ORG_BSNS_UNIT_ID
,      RTL_BSNS_UNIT_CD
,      DAY_CD
,      GLBL_ITEM_ID
,      RTL_SKU_ITEM_ID
,      RTL_SKU_ITEM_NBR
,      GLBL_ITEM_ID_TYP
,      UOM_CD
,      UOM_CD_PRMRY
,      UOM_CD_ALT
,      CRNCY_CD
,      ORDR_QTY
,      ORDR_QTY_PRMRY
,      ORDR_QTY_ALT
,      ORDR_AMT
,      ORDR_AMT_LCL
,      ORDR_AMT_RPT
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      CRTD_BY_DSR
,      LAST_UPDT_BY_DSR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MFG_SKU_ITEM_ID
,      ITM_TYP
FROM DDR.DDR_B_RTL_ORDR_ITEM_DAY#;

Dependencies

[top of page]

DDR.DDR_B_RTL_ORDR_ITEM_DAY# references the following:

SchemaDDR
TableDDR_B_RTL_ORDR_ITEM_DAY
DDR.DDR_B_RTL_ORDR_ITEM_DAY# is referenced by following:

SchemaAPPS
SynonymDDR_B_RTL_ORDR_ITEM_DAY