[Home] [Help]
[Dependency Information]
VIEW: APPS.DDR_R_MFG_ITEM_HCHY_UNION_V
Object Details
Object Name: | DDR_R_MFG_ITEM_HCHY_UNION_V |
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
MFG_ORG_CD |
VARCHAR2 |
(30) |
|
|
HCHY_ID |
NUMBER |
|
|
|
HCHY_CD |
VARCHAR2 |
(30) |
|
|
HCHY_LVL |
VARCHAR2 |
(8) |
|
|
EFF_FROM_DT |
DATE |
|
|
|
EFF_TO_DT |
DATE |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT MFG_ORG_CD
, HCHY_ID
, HCHY_CD
, HCHY_LVL
, EFF_FROM_DT
, EFF_TO_DT
FROM APPS.DDR_R_MFG_ITEM_HCHY_UNION_V;
Dependencies
[top of page]
APPS.DDR_R_MFG_ITEM_HCHY_UNION_V references the following:
-
APPS
-
DDR_R_MFG_ITEM
-
DDR_R_MFG_ITEM_CLASS
-
DDR_R_MFG_ITEM_CMPNY
-
DDR_R_MFG_ITEM_DIV
-
DDR_R_MFG_ITEM_GRP
-
DDR_R_MFG_ITEM_SBC
-
DDR_R_MFG_SKU_ITEM
-
PUBLIC
-
DUAL
-
-
APPS.DDR_R_MFG_ITEM_HCHY_UNION_V is not referenced by any database object