DBA Data[Home] [Help] [Dependency Information]

TABLE: EGO.EGO_AML_INTF

Object Details
Object Name: EGO_AML_INTF
Object Type: TABLE
Owner: EGO
FND Design Data: TableEGO.EGO_AML_INTF
Subobject Name:
Status: VALID


This table is used to store the interface records for AML


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EGO_AML_INTF_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnTRANSACTION_ID
EGO_AML_INTF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnDATA_SET_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15)
Refers to the concurrent request id
DATA_SET_ID NUMBER (15) Yes Refers to the data set that need to be processed
TRANSACTION_ID NUMBER (15)
Unique key to identify records in this table
PROCESS_FLAG NUMBER (15)
Indicates the status of the record
TRANSACTION_TYPE VARCHAR2 (15) Yes Indicates the action user wants to perform on the Production Data
INVENTORY_ITEM_ID NUMBER (15)
Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B
ITEM_NUMBER VARCHAR2 (240)
Refers to concatenated_segments from MTL_SYSTEM_ITEMS_B_KFV
ORGANIZATION_ID NUMBER (15)
Organization identifier.Foreign key to MTL_PARAMTERES
ORGANIZATION_CODE VARCHAR2 (3)
Refers to organization_code from MTL_PARAMETERS
MANUFACTURER_ID NUMBER (15)
Manufacturer identifier.Foreign key to MTL_MANUFACTURERS
MANUFACTURER_NAME VARCHAR2 (30)
Refers to manufacturer_name from MTL_MANUFACTURERS
MFG_PART_NUM VARCHAR2 (150)
Manufacturer Part Number
MRP_PLANNING_CODE NUMBER (15)
MRP Planning Code
DESCRIPTION VARCHAR2 (240)
Description of the Manufacturer Part Number
START_DATE DATE

Effective start date of the manufacturer part number
END_DATE DATE

Effective end date of the manufacturer part number
FIRST_ARTICLE_STATUS VARCHAR2 (30)
Refers to information about the First Article Status
FIRST_ARTICLE_STATUS_MEANING VARCHAR2 (80)
First Article Status meaning as seen in fnd_lookup_values
APPROVAL_STATUS VARCHAR2 (30)
Refers to information about the Approval Status
APPROVAL_STATUS_MEANING VARCHAR2 (80)
Approval Status meaning as seen in fnd_lookup_values
ATTRIBUTE_CATEGORY VARCHAR2 (30)
DFF Standard field - Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
DFF Standard field - Attribute1
ATTRIBUTE2 VARCHAR2 (150)
DFF Standard field - Attribute2
ATTRIBUTE3 VARCHAR2 (150)
DFF Standard field - Attribute3
ATTRIBUTE4 VARCHAR2 (150)
DFF Standard field - Attribute4
ATTRIBUTE5 VARCHAR2 (150)
DFF Standard field - Attribute5
ATTRIBUTE6 VARCHAR2 (150)
DFF Standard field - Attribute6
ATTRIBUTE7 VARCHAR2 (150)
DFF Standard field - Attribute7
ATTRIBUTE8 VARCHAR2 (150)
DFF Standard field - Attribute8
ATTRIBUTE9 VARCHAR2 (150)
DFF Standard field - Attribute9
ATTRIBUTE10 VARCHAR2 (150)
DFF Standard field - Attribute10
ATTRIBUTE11 VARCHAR2 (150)
DFF Standard field - Attribute11
ATTRIBUTE12 VARCHAR2 (150)
DFF Standard field - Attribute12
ATTRIBUTE13 VARCHAR2 (150)
DFF Standard field - Attribute13
ATTRIBUTE14 VARCHAR2 (150)
DFF Standard field - Attribute14
ATTRIBUTE15 VARCHAR2 (150)
DFF Standard field - Attribute15
CREATED_BY NUMBER (15)
One of the five standard "WHO" columns
CREATION_DATE DATE

One of the five standard "WHO" columns
LAST_UPDATED_BY NUMBER (15)
One of the five standard "WHO" columns
LAST_UPDATE_DATE DATE

One of the five standard "WHO" columns
LAST_UPDATE_LOGIN NUMBER (15)
One of the five standard "WHO" columns
PROGRAM_APPLICATION_ID NUMBER (15)
Used as a standard to replicate all columns from the production table
PROGRAM_ID NUMBER (15)
Used as a standard to replicate all columns from the production table
PROGRAM_UPDATE_DATE DATE

Used as a standard to replicate all columns from the production table
PROG_INT_NUM1 NUMBER (15)
Internal column used by the bulkload program. Not for user entry
PROG_INT_NUM2 NUMBER (15)
Internal column used by the bulkload program. Not for user entry
PROG_INT_NUM3 NUMBER (15)
Internal column used by the bulkload program. Not for user entry
PROG_INT_NUM4 NUMBER (15)
Internal column used by the bulkload program. Not for user entry
PROG_INT_CHAR1 VARCHAR2 (255)
Internal column used by the bulkload program. Not for user entry
PROG_INT_CHAR2 VARCHAR2 (2000)
Internal column used by the bulkload program. Not for user entry
CHANGE_ID NUMBER (15)
Used to store the change to which the record is associated
CHANGE_LINE_ID NUMBER (15)
Used to store the change line to which the record is associated
SOURCE_SYSTEM_ID NUMBER (37)
Source System Identifier
SOURCE_SYSTEM_REFERENCE VARCHAR2 (255)
Source System Reference
SOURCE_SYSTEM_REFERENCE_DESC VARCHAR2 (240)
Source System Reference Description
Query Text

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


SELECT REQUEST_ID
,      DATA_SET_ID
,      TRANSACTION_ID
,      PROCESS_FLAG
,      TRANSACTION_TYPE
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      MANUFACTURER_ID
,      MANUFACTURER_NAME
,      MFG_PART_NUM
,      MRP_PLANNING_CODE
,      DESCRIPTION
,      START_DATE
,      END_DATE
,      FIRST_ARTICLE_STATUS
,      FIRST_ARTICLE_STATUS_MEANING
,      APPROVAL_STATUS
,      APPROVAL_STATUS_MEANING
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROG_INT_NUM1
,      PROG_INT_NUM2
,      PROG_INT_NUM3
,      PROG_INT_NUM4
,      PROG_INT_CHAR1
,      PROG_INT_CHAR2
,      CHANGE_ID
,      CHANGE_LINE_ID
,      SOURCE_SYSTEM_ID
,      SOURCE_SYSTEM_REFERENCE
,      SOURCE_SYSTEM_REFERENCE_DESC
FROM EGO.EGO_AML_INTF;

Dependencies

[top of page]

EGO.EGO_AML_INTF does not reference any database object

EGO.EGO_AML_INTF is referenced by following:

SchemaEGO
ViewEGO_AML_INTF#