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]

TYPE: APPS.INV_EBI_ITEM_MAIN_OBJ

Object Details

Object Name:	INV_EBI_ITEM_MAIN_OBJ
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
API_VERSION	NUMBER
INIT_MSG_LIST	VARCHAR2	(1)
LANGUAGE_CODE	VARCHAR2	(4)
TEMPLATE_ID	NUMBER
TEMPLATE_NAME	VARCHAR2	(30)
COPY_INVENTORY_ITEM_ID	NUMBER
ORGANIZATION_ID	NUMBER
ORGANIZATION_CODE	VARCHAR2	(3)
DESCRIPTION	VARCHAR2	(240)
LONG_DESCRIPTION	VARCHAR2	(4000)
PRIMARY_UOM_CODE	VARCHAR2	(3)
ITEM_TYPE	VARCHAR2	(30)
INVENTORY_ITEM_STATUS_CODE	VARCHAR2	(10)
ALLOWED_UNITS_LOOKUP_CODE	NUMBER
ITEM_CATALOG_GROUP_ID	NUMBER
ITEM_CATALOG_GROUP_CODE	VARCHAR2	(40)
SECONDARY_UOM_CODE	VARCHAR2	(3)
DUAL_UOM_DEVIATION_HIGH	NUMBER
DUAL_UOM_DEVIATION_LOW	NUMBER
TRACKING_QUANTITY_IND	VARCHAR2	(30)
ONT_PRICING_QTY_SOURCE	VARCHAR2	(20)
SECONDARY_DEFAULT_IND	VARCHAR2	(30)
ITEM_NUMBER	VARCHAR2	(2000)
SEGMENT1	VARCHAR2	(40)
SEGMENT2	VARCHAR2	(40)
SEGMENT3	VARCHAR2	(40)
SEGMENT4	VARCHAR2	(40)
SEGMENT5	VARCHAR2	(40)
SEGMENT6	VARCHAR2	(40)
SEGMENT7	VARCHAR2	(40)
SEGMENT8	VARCHAR2	(40)
SEGMENT9	VARCHAR2	(40)
SEGMENT10	VARCHAR2	(40)
SEGMENT11	VARCHAR2	(40)
SEGMENT12	VARCHAR2	(40)
SEGMENT13	VARCHAR2	(40)
SEGMENT14	VARCHAR2	(40)
SEGMENT15	VARCHAR2	(40)
SEGMENT16	VARCHAR2	(40)
SEGMENT17	VARCHAR2	(40)
SEGMENT18	VARCHAR2	(40)
SEGMENT19	VARCHAR2	(40)
SEGMENT20	VARCHAR2	(40)
SUMMARY_FLAG	VARCHAR2	(1)
ENABLED_FLAG	VARCHAR2	(1)
START_DATE_ACTIVE	DATE
END_DATE_ACTIVE	DATE
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
LIFECYCLE_ID	NUMBER
LIFECYCLE_NAME	VARCHAR2	(240)
CURRENT_PHASE_ID	NUMBER
CURRENT_PHASE_NAME	VARCHAR2	(240)
REVISION_ID	NUMBER
REVISION_CODE	VARCHAR2	(3)
REVISION_LABEL	VARCHAR2	(80)
REVISION_DESCRIPTION	VARCHAR2	(240)
EFFECTIVITY_DATE	DATE
REV_LIFECYCLE_ID	NUMBER
REV_LIFECYCLE_NAME	VARCHAR2	(240)
REV_CURRENT_PHASE_ID	NUMBER
REV_CURRENT_PHASE_NAME	VARCHAR2	(240)
APPLY_TEMPLATE	VARCHAR2	(30)
INVENTORY_ITEM_ID	NUMBER
ITEM_NAME	VARCHAR2	(100)
MASTER_ORGANIZATION_ID	NUMBER
MASTER_ORGANIZATION_CODE	VARCHAR2	(3)
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(30)
CROSS_REFERENCE_TYPE	VARCHAR2	(25)
REVISION_REASON	VARCHAR2	(30)
START_DATE_ACTIVE_STR	VARCHAR2	(30)
END_DATE_ACTIVE_STR	VARCHAR2	(30)
CREATION_DATE_STR	VARCHAR2	(30)
LAST_UPDATE_DATE_STR	VARCHAR2	(30)
PROGRAM_UPDATE_DATE_STR	VARCHAR2	(30)
EFFECTIVITY_DATE_STR	VARCHAR2	(30)
ITEM_DESC_LANG_OBJ_TBL_TYPE	INV_EBI_DESC_LANG_OBJ_TBL_TYPE

Dependencies

[top of page]

APPS.INV_EBI_ITEM_MAIN_OBJ references the following:

APPS: INV_EBI_DESC_LANG_OBJ_TBL_TYPE
SYS: STANDARD - show dependent code

APPS.INV_EBI_ITEM_MAIN_OBJ is referenced by following:

APPS: INV_EBI_CHANGE_ORDER_PUB - show dependent code; INV_EBI_ITEM_HELPER - show dependent code; INV_EBI_ITEM_OBJ; INV_EBI_ITEM_PUB - show dependent code