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.EGO_IMPORT_BATCH_DETAILS_V

Object Details

Object Name:	EGO_IMPORT_BATCH_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EGO.EGO_IMPORT_BATCH_DETAILS_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

View EGO_IMPORT_BATCH_DETAILS_V provides detailed information (including translatable information) about import batches. Each row of this view provides the name, description, status, type, id, asignee, organization, source system id, and detailed information such as matching rules, change order options, and structure for a given batch. The unique identifier for each row is BATCH_ID.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	Id of the batch.
ORGANIZATION_ID	NUMBER		Yes	Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B
SOURCE_SYSTEM_ID	NUMBER		Yes	Id of the source system.
SOURCE_SYSTEM_NAME	VARCHAR2	(80)		Name of the source system
BATCH_TYPE	VARCHAR2	(30)	Yes	Type of the batch (Structure, Item etc)
BATCH_TYPE_MEANING	VARCHAR2	(240)		Meaning of the type
ASSIGNEE	NUMBER			Identifier of Person this batch is assigned to.
ASSIGNEE_NAME	VARCHAR2	(4000)		name of the person this batch assigned to
BATCH_STATUS	VARCHAR2	(1)	Yes	status of the batch (A, ..etc)
BATCH_STATUS_MEANING	VARCHAR2	(4000)		Meaning of the batch status (Active, .. etc)
BATCH_NAME	VARCHAR2	(80)	Yes	Name of the batch
BATCH_DESCRIPTION	VARCHAR2	(240)		Description of the batch
LAST_MATCH_REQUEST_ID	NUMBER			This column holds the latest concurrent request id of matching concurrent program ran for this batch.
LAST_IMPORT_REQUEST_ID	NUMBER			This column holds the latest concurrent request id of import concurrent program ran for this batch.
CREATED_BY	NUMBER		Yes	Standard WHO column
CREATOR_NAME	VARCHAR2	(4000)		Name of the creator of batch
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column
DEF_MATCH_RULE_CUST_APP_ID	NUMBER			Default Match Rule Information
DEF_MATCH_RULE_CUST_CODE	VARCHAR2	(30)		Default Match Rule Information
DEF_MATCH_RULE_RN_APP_ID	NUMBER			Default Match Rule Information
DEF_MATCH_RULE_RN_CODE	VARCHAR2	(30)		Default Match Rule Information
DEFAULT_MATCH_RULE_MEANING	VARCHAR2	(80)		Default Match Rule Information
OPTION_SET_ID	NUMBER		Yes	Id of the option set.
APPLY_DEF_MATCH_RULE_ALL	VARCHAR2	(1)		Apply the default match rule to all records from this source system.
APPLY_DEFMATCHRULEALL_MEANING	VARCHAR2	(4000)		Apply the default match rule to all records from this source system.
MATCH_ON_DATA_LOAD	VARCHAR2	(1)		Automatically match on data load.
MATCH_ON_DATA_LOAD_MEANING	VARCHAR2	(4000)		Automatically match on data load.
CONFIRM_SINGLE_MATCH	VARCHAR2	(1)		Automatically confirm single matches.
CONFIRM_SINGLE_MATCH_MEANING	VARCHAR2	(4000)		Automatically confirm single matches.
IMPORT_ON_DATA_LOAD	VARCHAR2	(1)		Automatically import on data load
IMPORT_ON_DATA_LOAD_MEANING	VARCHAR2	(4000)		Automatically import on data load
REVISION_IMPORT_POLICY	VARCHAR2	(30)		Revision import policy, e.g. L for update latest, or N for create new.
REVISION_IMPORT_POLICY_MEANING	VARCHAR2	(4000)		Meaning of Revision policy
IMPORT_XREF_ONLY	VARCHAR2	(1)		Import cross reference only.
IMPORT_XREF_ONLY_MEANING	VARCHAR2	(4000)		Meaning of the cross reference only
STRUCTURE_TYPE_ID	NUMBER			Id of the structure type.(FK of BOM_STRUCTURE_TYPES_B. STRUCTURE_TYPE_ID)
STRUCTURE_TYPE_DISPLAY_NAME	VARCHAR2	(80)		Display name of the structure type
STRUCTURE_NAME	VARCHAR2	(10)		Internal code of the structure name.
STRUCTURE_DISPLAY_NAME	VARCHAR2	(4000)		Display name of the structure name.
STRUCTURE_EFFECTIVITY_TYPE	NUMBER			Effectivity control type of the structure.
STRUCTURE_EFF_TYPE_MEANING	VARCHAR2	(80)		Meaning of Effectivity control type.
EFFECTIVITY_DATE	DATE			Effectivity date.
FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		Overloaded column to store information for serial number or unit effectivity.
STRUCTURE_CONTENT	VARCHAR2	(30)		Structure contains changed components only.
STRUCTURE_CONTENT_MEANING	VARCHAR2	(4000)		Structure content Meaning
CHANGE_ORDER_CREATION	VARCHAR2	(30)		Create new change order or add to existing change order.
CHANGE_ORDER_CREATION_MEANING	VARCHAR2	(4000)		Change order Creation Meaning
ADD_ALL_TO_CHANGE_FLAG	VARCHAR2	(1)		Add all imported items to change order.
ADD_ALL_TO_CHANGE_FLAG_MEANING	VARCHAR2	(4000)		ADD_ALL_TO_CHANGE_FLAG Meaning
CHANGE_MGMT_TYPE_CODE	VARCHAR2	(30)		Change Management Type Code.
CHANGE_MGMT_TYPE_MEANING	VARCHAR2	(80)		CHANGE_MGMT_TYPE_CODE Meaning
CHANGE_TYPE_ID	NUMBER			Change order type.
CHANGE_TYPE_NAME	VARCHAR2	(80)		Change order type name.
CHANGE_NOTICE	VARCHAR2	(10)		Change order number.
CHANGE_NAME	VARCHAR2	(240)		Change order name.
CHANGE_DESCRIPTION	VARCHAR2	(2000)		Change order description.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Version number for concurrency control purpose.
OBJECT_VERSION_NUMBER1	NUMBER		Yes	Version number for concurrency control purpose.
NIR_OPTION	VARCHAR2	(1)		This column provides the New Item Request creation option. Valid values are N (None), C (One per item catalog category), I (One per Item).
NIR_OPTION_MEANING	VARCHAR2	(4000)		This column provides the New Item Request Meaning. Possible values are 'None' and 'One per Item'.
SCHEDULED_REQUEST_ID	NUMBER			This column provides the scheduled request identifier
IMPORT_SCHEDULE_DATE	DATE			This column provides the import scheduled request date
ENABLED_FOR_DATA_POOL	VARCHAR2	(1)		This column provides whether batch/source system is enabled for Data Pool or not. If a batch is enabled for data pool, then only it can be used for inbound messages.
ENABLED_FOR_DATA_POOL_MEANING	VARCHAR2	(4000)		This column provides the enabled for data pool meaning. Possible values include 'Yes' and 'No'.
CONFIRM_NO_MATCH	VARCHAR2	(1)		Automatically Confirm New Item on No Match
CONFIRM_NO_MATCH_MEANING	VARCHAR2	(4000)		Automatically Confirm New Item on No Match

Query Text

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


SELECT BATCH_ID
,      ORGANIZATION_ID
,      SOURCE_SYSTEM_ID
,      SOURCE_SYSTEM_NAME
,      BATCH_TYPE
,      BATCH_TYPE_MEANING
,      ASSIGNEE
,      ASSIGNEE_NAME
,      BATCH_STATUS
,      BATCH_STATUS_MEANING
,      BATCH_NAME
,      BATCH_DESCRIPTION
,      LAST_MATCH_REQUEST_ID
,      LAST_IMPORT_REQUEST_ID
,      CREATED_BY
,      CREATOR_NAME
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DEF_MATCH_RULE_CUST_APP_ID
,      DEF_MATCH_RULE_CUST_CODE
,      DEF_MATCH_RULE_RN_APP_ID
,      DEF_MATCH_RULE_RN_CODE
,      DEFAULT_MATCH_RULE_MEANING
,      OPTION_SET_ID
,      APPLY_DEF_MATCH_RULE_ALL
,      APPLY_DEFMATCHRULEALL_MEANING
,      MATCH_ON_DATA_LOAD
,      MATCH_ON_DATA_LOAD_MEANING
,      CONFIRM_SINGLE_MATCH
,      CONFIRM_SINGLE_MATCH_MEANING
,      IMPORT_ON_DATA_LOAD
,      IMPORT_ON_DATA_LOAD_MEANING
,      REVISION_IMPORT_POLICY
,      REVISION_IMPORT_POLICY_MEANING
,      IMPORT_XREF_ONLY
,      IMPORT_XREF_ONLY_MEANING
,      STRUCTURE_TYPE_ID
,      STRUCTURE_TYPE_DISPLAY_NAME
,      STRUCTURE_NAME
,      STRUCTURE_DISPLAY_NAME
,      STRUCTURE_EFFECTIVITY_TYPE
,      STRUCTURE_EFF_TYPE_MEANING
,      EFFECTIVITY_DATE
,      FROM_END_ITEM_UNIT_NUMBER
,      STRUCTURE_CONTENT
,      STRUCTURE_CONTENT_MEANING
,      CHANGE_ORDER_CREATION
,      CHANGE_ORDER_CREATION_MEANING
,      ADD_ALL_TO_CHANGE_FLAG
,      ADD_ALL_TO_CHANGE_FLAG_MEANING
,      CHANGE_MGMT_TYPE_CODE
,      CHANGE_MGMT_TYPE_MEANING
,      CHANGE_TYPE_ID
,      CHANGE_TYPE_NAME
,      CHANGE_NOTICE
,      CHANGE_NAME
,      CHANGE_DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      OBJECT_VERSION_NUMBER1
,      NIR_OPTION
,      NIR_OPTION_MEANING
,      SCHEDULED_REQUEST_ID
,      IMPORT_SCHEDULE_DATE
,      ENABLED_FOR_DATA_POOL
,      ENABLED_FOR_DATA_POOL_MEANING
,      CONFIRM_NO_MATCH
,      CONFIRM_NO_MATCH_MEANING
FROM APPS.EGO_IMPORT_BATCH_DETAILS_V;

Dependencies

[top of page]

APPS.EGO_IMPORT_BATCH_DETAILS_V references the following:

APPS: AK_CUSTOMIZATIONS_TL; BOM_ALTERNATE_DESIGNATORS_TL; BOM_GLOBALS - show dependent code; BOM_STRUCTURE_TYPES_TL; EGO_IMPORT_BATCHES_VL; EGO_IMPORT_OPTION_SETS; EGO_ITEM_UTIL_PVT - show dependent code; ENG_CHANGE_ORDER_TYPES; ENG_CHANGE_ORDER_TYPES_TL; FND_CONCURRENT_REQUESTS; FND_OBJECTS_VL; HZ_ORIG_SYSTEMS_TL; MFG_LOOKUPS

APPS.EGO_IMPORT_BATCH_DETAILS_V is referenced by following:

APPS: EGO_IMPORT_PVT - show dependent code