[Home] [Help] [Dependency Information]
Object Name: | EGO_AML_INTF |
---|---|
Object Type: | TABLE |
Owner: | EGO |
FND Design Data: | EGO.EGO_AML_INTF |
Subobject Name: | |
Status: | VALID |
This table is used to store the interface records for AML
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EGO_AML_INTF_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | TRANSACTION_ID |
EGO_AML_INTF_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | DATA_SET_ID |
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 |
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;
EGO.EGO_AML_INTF does not reference any database object
EGO.EGO_AML_INTF is referenced by following:
|
|
|