eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.DDR_R_INV_LOC_UNPIVOT_V

Object Details

Object Name:	DDR_R_INV_LOC_UNPIVOT_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
REC_ID	NUMBER
ORG_CD	VARCHAR2	(30)
BSNS_UNIT_CD	VARCHAR2	(30)
P_INV_LOC_CD	VARCHAR2	(30)
P_INV_LOC_TYP_CD	VARCHAR2	(30)
P_INV_LOC_DESC	VARCHAR2	(240)
P_LAYOUT_SHAPE	VARCHAR2	(40)
P_LNR_SZ	NUMBER
P_SQR_SZ	NUMBER
P_CUBIC_SZ	NUMBER
P_LOC_CORDNT_X	NUMBER
P_LOC_CORDNT_Y	NUMBER
P_LOC_CORDNT_Z	NUMBER
P_UOM_CD	VARCHAR2	(30)
P_SLNG_LOC_TYP_CD	VARCHAR2	(30)
P_NBR_OF_FCNGS	NUMBER
SRC_SYS_DT	DATE
SRC_SYS_IDNT	VARCHAR2	(40)

Query Text

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


SELECT REC_ID
,      ORG_CD
,      BSNS_UNIT_CD
,      P_INV_LOC_CD
,      P_INV_LOC_TYP_CD
,      P_INV_LOC_DESC
,      P_LAYOUT_SHAPE
,      P_LNR_SZ
,      P_SQR_SZ
,      P_CUBIC_SZ
,      P_LOC_CORDNT_X
,      P_LOC_CORDNT_Y
,      P_LOC_CORDNT_Z
,      P_UOM_CD
,      P_SLNG_LOC_TYP_CD
,      P_NBR_OF_FCNGS
,      SRC_SYS_DT
,      SRC_SYS_IDNT
FROM APPS.DDR_R_INV_LOC_UNPIVOT_V;

Dependencies

[top of page]

APPS.DDR_R_INV_LOC_UNPIVOT_V references the following:

APPS: DDR_I_ORG_BSNS_UNIT

APPS.DDR_R_INV_LOC_UNPIVOT_V is not referenced by any database object