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]

TABLE: EGO.EGO_MFG_PART_NUM_CHGS

Object Details

Object Name:	EGO_MFG_PART_NUM_CHGS
Object Type:	TABLE
Owner:	EGO
FND Design Data:	EGO.EGO_MFG_PART_NUM_CHGS
Subobject Name:
Status:	VALID

This table stores pending and history data for Approved Manufacturers

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_MFG_PART_NUM_CHGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID MANUFACTURER_ID MFG_PART_NUM INVENTORY_ITEM_ID CHANGE_LINE_ID ACD_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
MANUFACTURER_ID	NUMBER	(15)	Yes	Manufacturer identifier.Foreign key to MTL_MANUFACTURERS
MFG_PART_NUM	VARCHAR2	(150)	Yes	Identifier for Manufacturer Part Number. The value is obtained from MTL_MFG_PART_NUMBERS
INVENTORY_ITEM_ID	NUMBER	(15)	Yes	Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B
CREATED_BY	NUMBER	(15)	Yes	One of the five standard "WHO" columns
CREATION_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE		Yes	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER	(15)		One of the five standard "WHO" columns
ORGANIZATION_ID	NUMBER	(15)		Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B
MRP_PLANNING_CODE	NUMBER	(15)		Stores the Mrp Planning detail
DESCRIPTION	VARCHAR2	(240)		Stores the description of the Manufacturer Part Number
START_DATE	DATE			Stores the start date for the Manufacturer Part Number - Item association
END_DATE	DATE			Stores the end date for the Manufacturer Part Number - Item association
FIRST_ARTICLE_STATUS	VARCHAR2	(30)		Stores the first article status for the Manufacturer Part Number - Item association
APPROVAL_STATUS	VARCHAR2	(30)		Stores the approval status for the Manufacturer Part Number - Item association
CHANGE_ID	NUMBER	(15)		Attribute to store change id for a pending change
CHANGE_LINE_ID	NUMBER	(15)		Attribute to store change line id for a pending change
ACD_TYPE	VARCHAR2	(10)		Attribute to store change type - Add, Change, Delete and History for a change
IMPLMENTATION_DATE	DATE			Implementation Date
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute Category
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
REQUEST_ID	NUMBER	(15)		Request Id
PROGRAM_APPLICATION_ID	NUMBER	(15)		Program Application Id
PROGRAM_ID	NUMBER	(15)		Program Id
PROGRAM_UPDATE_DATE	DATE			Program Update Date

Query Text

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


SELECT MANUFACTURER_ID
,      MFG_PART_NUM
,      INVENTORY_ITEM_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      MRP_PLANNING_CODE
,      DESCRIPTION
,      START_DATE
,      END_DATE
,      FIRST_ARTICLE_STATUS
,      APPROVAL_STATUS
,      CHANGE_ID
,      CHANGE_LINE_ID
,      ACD_TYPE
,      IMPLMENTATION_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM EGO.EGO_MFG_PART_NUM_CHGS;

Dependencies

[top of page]

EGO.EGO_MFG_PART_NUM_CHGS does not reference any database object

EGO.EGO_MFG_PART_NUM_CHGS is referenced by following:

APPS: EGO_MFG_PART_NUM_CHGS