[Home] [Help]
[Dependency Information]
VIEW: GR.GR_ITEM_GENERAL_MIG#
Object Details
Object Name: | GR_ITEM_GENERAL_MIG# |
Object Type: | VIEW |
Owner: | GR |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ITEM_CODE |
VARCHAR2 |
(32) |
Yes |
|
ORGANIZATION_ID |
NUMBER |
(15) |
Yes |
|
INVENTORY_ITEM_ID |
NUMBER |
(15) |
|
|
MIGRATION_IND |
NUMBER |
(5) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_CODE
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, MIGRATION_IND
FROM GR.GR_ITEM_GENERAL_MIG#;
Dependencies
[top of page]
GR.GR_ITEM_GENERAL_MIG# references the following:
-
GR
-
GR_ITEM_GENERAL_MIG
GR.GR_ITEM_GENERAL_MIG# is referenced by following:
-
APPS
-
GR_ITEM_GENERAL_MIG