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

VIEW: DDR.DDR_R_INV_LOC#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30) Yes
INV_LOC_ID NUMBER
Yes
ORG_CD VARCHAR2 (30) Yes
ORG_BSNS_UNIT_ID NUMBER
Yes
BSNS_UNIT_CD VARCHAR2 (30) Yes
INV_LOC_CD VARCHAR2 (30) Yes
INV_LOC_TYP_CD VARCHAR2 (30)
INV_LOC_DESC VARCHAR2 (240)
LAYOUT_SHAPE VARCHAR2 (40)
LNR_SZ NUMBER

SQR_SZ NUMBER

CUBIC_SZ NUMBER

LOC_CORDNT_X NUMBER

LOC_CORDNT_Y NUMBER

LOC_CORDNT_Z NUMBER

UOM_CD VARCHAR2 (30)
SLNG_LOC_TYP_CD VARCHAR2 (30)
NBR_OF_FCNGS 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
Query Text

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


SELECT MFG_ORG_CD
,      INV_LOC_ID
,      ORG_CD
,      ORG_BSNS_UNIT_ID
,      BSNS_UNIT_CD
,      INV_LOC_CD
,      INV_LOC_TYP_CD
,      INV_LOC_DESC
,      LAYOUT_SHAPE
,      LNR_SZ
,      SQR_SZ
,      CUBIC_SZ
,      LOC_CORDNT_X
,      LOC_CORDNT_Y
,      LOC_CORDNT_Z
,      UOM_CD
,      SLNG_LOC_TYP_CD
,      NBR_OF_FCNGS
,      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
FROM DDR.DDR_R_INV_LOC#;

Dependencies

[top of page]

DDR.DDR_R_INV_LOC# references the following:

SchemaDDR
TableDDR_R_INV_LOC
DDR.DDR_R_INV_LOC# is referenced by following:

SchemaAPPS
SynonymDDR_R_INV_LOC