Skip to content

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

VIEW: DDR.DDR_S_RTL_INV_ITEM#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
REC_ID NUMBER
Yes
TRANS_DT DATE
Yes
MFG_ORG_CD VARCHAR2 (30)
RTL_ORG_CD VARCHAR2 (30)
ORG_BSNS_UNIT_ID NUMBER

RTL_BSNS_UNIT_CD VARCHAR2 (30)
GLBL_ITEM_ID VARCHAR2 (30)
RTL_SKU_ITEM_ID NUMBER

RTL_SKU_ITEM_NBR VARCHAR2 (30)
DAY_CD VARCHAR2 (30)
GLBL_ITEM_ID_TYP VARCHAR2 (30)
INV_LOC_TYP_CD VARCHAR2 (30)
INV_LOC_ID NUMBER

INV_LOC_CD VARCHAR2 (30)
UOM_CD VARCHAR2 (30)
UOM_CD_PRMRY VARCHAR2 (30)
UOM_CD_ALT VARCHAR2 (30)
CRNCY_CD VARCHAR2 (30)
ON_HAND_QTY NUMBER

ON_HAND_QTY_PRMRY NUMBER

ON_HAND_QTY_ALT NUMBER

RECVD_QTY NUMBER

RECVD_QTY_PRMRY NUMBER

RECVD_QTY_ALT NUMBER

IN_TRANSIT_QTY NUMBER

IN_TRANSIT_QTY_PRMRY NUMBER

IN_TRANSIT_QTY_ALT NUMBER

BCK_ORDR_QTY NUMBER

BCK_ORDR_QTY_PRMRY NUMBER

BCK_ORDR_QTY_ALT NUMBER

QLTY_HOLD_QTY NUMBER

QLTY_HOLD_QTY_PRMRY NUMBER

QLTY_HOLD_QTY_ALT NUMBER

ON_HAND_NET_COST_AMT NUMBER

ON_HAND_NET_COST_AMT_LCL NUMBER

ON_HAND_NET_COST_AMT_RPT NUMBER

RECVD_NET_COST_AMT NUMBER

RECVD_NET_COST_AMT_LCL NUMBER

RECVD_NET_COST_AMT_RPT NUMBER

IN_TRANSIT_NET_COST_AMT NUMBER

IN_TRANSIT_NET_COST_AMT_LCL NUMBER

IN_TRANSIT_NET_COST_AMT_RPT NUMBER

BCKORDR_NET_COST_AMT NUMBER

BCKORDR_NET_COST_AMT_LCL NUMBER

BCKORDR_NET_COST_AMT_RPT NUMBER

QLTY_HOLD_NET_COST_AMT NUMBER

QLTY_HOLD_NET_COST_AMT_LCL NUMBER

QLTY_HOLD_NET_COST_AMT_RPT NUMBER

ON_HAND_RTL_AMT NUMBER

ON_HAND_RTL_AMT_LCL NUMBER

ON_HAND_RTL_AMT_RPT NUMBER

RECVD_RTL_AMT NUMBER

RECVD_RTL_AMT_LCL NUMBER

RECVD_RTL_AMT_RPT NUMBER

IN_TRANSIT_RTL_AMT NUMBER

IN_TRANSIT_RTL_AMT_LCL NUMBER

IN_TRANSIT_RTL_AMT_RPT NUMBER

BCKORDR_RTL_AMT NUMBER

BCKORDR_RTL_AMT_LCL NUMBER

BCKORDR_RTL_AMT_RPT NUMBER

QLTY_HOLD_RTL_AMT NUMBER

QLTY_HOLD_RTL_AMT_LCL NUMBER

QLTY_HOLD_RTL_AMT_RPT NUMBER

SRC_SYS_IDNT VARCHAR2 (40) Yes
SRC_SYS_DT DATE
Yes
LOAD_ID NUMBER
Yes
ITM_TYP VARCHAR2 (1)
MFG_SKU_ITEM_ID NUMBER

Query Text

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


SELECT REC_ID
,      TRANS_DT
,      MFG_ORG_CD
,      RTL_ORG_CD
,      ORG_BSNS_UNIT_ID
,      RTL_BSNS_UNIT_CD
,      GLBL_ITEM_ID
,      RTL_SKU_ITEM_ID
,      RTL_SKU_ITEM_NBR
,      DAY_CD
,      GLBL_ITEM_ID_TYP
,      INV_LOC_TYP_CD
,      INV_LOC_ID
,      INV_LOC_CD
,      UOM_CD
,      UOM_CD_PRMRY
,      UOM_CD_ALT
,      CRNCY_CD
,      ON_HAND_QTY
,      ON_HAND_QTY_PRMRY
,      ON_HAND_QTY_ALT
,      RECVD_QTY
,      RECVD_QTY_PRMRY
,      RECVD_QTY_ALT
,      IN_TRANSIT_QTY
,      IN_TRANSIT_QTY_PRMRY
,      IN_TRANSIT_QTY_ALT
,      BCK_ORDR_QTY
,      BCK_ORDR_QTY_PRMRY
,      BCK_ORDR_QTY_ALT
,      QLTY_HOLD_QTY
,      QLTY_HOLD_QTY_PRMRY
,      QLTY_HOLD_QTY_ALT
,      ON_HAND_NET_COST_AMT
,      ON_HAND_NET_COST_AMT_LCL
,      ON_HAND_NET_COST_AMT_RPT
,      RECVD_NET_COST_AMT
,      RECVD_NET_COST_AMT_LCL
,      RECVD_NET_COST_AMT_RPT
,      IN_TRANSIT_NET_COST_AMT
,      IN_TRANSIT_NET_COST_AMT_LCL
,      IN_TRANSIT_NET_COST_AMT_RPT
,      BCKORDR_NET_COST_AMT
,      BCKORDR_NET_COST_AMT_LCL
,      BCKORDR_NET_COST_AMT_RPT
,      QLTY_HOLD_NET_COST_AMT
,      QLTY_HOLD_NET_COST_AMT_LCL
,      QLTY_HOLD_NET_COST_AMT_RPT
,      ON_HAND_RTL_AMT
,      ON_HAND_RTL_AMT_LCL
,      ON_HAND_RTL_AMT_RPT
,      RECVD_RTL_AMT
,      RECVD_RTL_AMT_LCL
,      RECVD_RTL_AMT_RPT
,      IN_TRANSIT_RTL_AMT
,      IN_TRANSIT_RTL_AMT_LCL
,      IN_TRANSIT_RTL_AMT_RPT
,      BCKORDR_RTL_AMT
,      BCKORDR_RTL_AMT_LCL
,      BCKORDR_RTL_AMT_RPT
,      QLTY_HOLD_RTL_AMT
,      QLTY_HOLD_RTL_AMT_LCL
,      QLTY_HOLD_RTL_AMT_RPT
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      LOAD_ID
,      ITM_TYP
,      MFG_SKU_ITEM_ID
FROM DDR.DDR_S_RTL_INV_ITEM#;

Dependencies

[top of page]

DDR.DDR_S_RTL_INV_ITEM# references the following:

SchemaDDR
TableDDR_S_RTL_INV_ITEM
DDR.DDR_S_RTL_INV_ITEM# is referenced by following:

SchemaAPPS
SynonymDDR_S_RTL_INV_ITEM