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

TABLE: INV.MTL_CI_INTERFACE

Object Details
Object Name: MTL_CI_INTERFACE
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_CI_INTERFACE
Subobject Name:
Status: VALID


MTL_CI_INTERFACE serves as an interface between users and Oracle
Inventory's customer item functionality. Users populate this table
with customer item information, and a PL/SQL concurrent
program, launched by the user, processes the information and
inserts records into the MTL_CUSTOMER_ITEMS table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PROCESS_FLAG VARCHAR2 (1) Yes Used to specify whether the interface record needs to be processed
PROCESS_MODE NUMBER
Yes Used to specify mode in which interface records are to be processed
LOCK_FLAG VARCHAR2 (1) Yes Flag indicating whether the record in the interface table has been locked and is being processed by a concurrent program
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TRANSACTION_TYPE VARCHAR2 (6) Yes Type of action to perform on the interface record
CUSTOMER_NAME VARCHAR2 (50)
Customer name. Either the CUSTOMER_NAME, CUSTOMER_NUMBER, or CUSTOMER_ID column must be populated to specify a customer
CUSTOMER_NUMBER VARCHAR2 (30)
Customer number
CUSTOMER_ID NUMBER

Customer identifier
CUSTOMER_CATEGORY_CODE VARCHAR2 (30)
Customer category code. Either the CUSTOMER_CATEGORY_CODE orCUSTOMER_CATEGORY column must be populated to specify a customer category
CUSTOMER_CATEGORY VARCHAR2 (80)
Customer category name
ADDRESS1 VARCHAR2 (240)
Address column. Either the ADDRESS_ID orthe ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, STATE, COUNTRY,POSTAL_CODE columns must be populated to specify a customer address
ADDRESS2 VARCHAR2 (240)
Address column. Either the ADDRESS_ID or the ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, STATE, COUNTRY, POSTAL_CODE columns must be populated to specify a customer address
ADDRESS3 VARCHAR2 (240)
Address column. Either the ADDRESS_ID or the ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, STATE, COUNTRY, POSTAL_CODE columns must be populated to specify a customer address
ADDRESS4 VARCHAR2 (240)
Address column. Either the ADDRESS_ID or the ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, STATE, COUNTRY, POSTAL_CODE columns must be populated to specify a customer address
CITY VARCHAR2 (50)
Address city column. Either the ADDRESS_ID or the ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, STATE, COUNTRY, POSTAL_CODE columns must be populated to specify a customer address
STATE VARCHAR2 (50)
Address state column. Either the ADDRESS_ID or the ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, STATE, COUNTRY, POSTAL_CODE columns must be populated to specify a customer address
COUNTY VARCHAR2 (50)
Address county column. Either the ADDRESS_ID or the ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, STATE, COUNTRY, POSTAL_CODE columns must be populated to specify a customer address
COUNTRY VARCHAR2 (50)
Address country column. Either the ADDRESS_ID or the ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, STATE, COUNTRY, POSTAL_CODE columns must be populated to specify a customer address
POSTAL_CODE VARCHAR2 (30)
Address postal code column. Either the ADDRESS_ID or the ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, STATE, COUNTRY, POSTAL_CODE columns must be populated to specify a customer address
ADDRESS_ID NUMBER

Customer address unique identifier. Either the ADDRESS_ID or the ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, STATE, COUNTRY, POSTAL_CODE columns must be populated to specify a customer address
CUSTOMER_ITEM_NUMBER VARCHAR2 (50) Yes Customer item part number
ITEM_DEFINITION_LEVEL_DESC VARCHAR2 (30)
Item definition level description
ITEM_DEFINITION_LEVEL VARCHAR2 (1)
Customer item definition level. These levels are: 1 (Customer), 2 (Address Category), 3 (Address)
CUSTOMER_ITEM_DESC VARCHAR2 (240)
Customer item description
MODEL_CUSTOMER_ITEM_NUMBER VARCHAR2 (50)
Model number of the customer item model associated with this customer item. Either the MODEL_CUSTOMER_ITEM_NUMBER or MODEL_CUSTOMER_ITEM_ID column must be populated to specify a customer item model
MODEL_CUSTOMER_ITEM_ID NUMBER

Model identifier of the customer item model associated with the customer item. Either the MODEL_CUSTOMER_ITEM_NUMBER or MODEL_CUSTOMER_ITEM_ID column must be populated to specify a customer item model
COMMODITY_CODE VARCHAR2 (30)
Commodity code associated with the customer item. Either the COMMODITY_CODE or COMMODITY_CODE_ID column must be populated to specify a customer item commodity code
COMMODITY_CODE_ID NUMBER

Commodity code identifier of the commodity code associated with the customer item. Either the COMMODITY_CODE or COMMODITY_CODE_ID column must be populated to specify a customer item commodity code
MASTER_CONTAINER_SEGMENT2 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT3 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT4 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT5 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT6 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT7 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT8 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT9 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT10 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT11 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT12 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT13 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT14 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT15 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT16 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT17 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT18 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT19 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER_SEGMENT20 VARCHAR2 (40)
Master container item key flexfield segment
MASTER_CONTAINER VARCHAR2 (2000)
Master container item name (flexfield concatenated segments)
MASTER_CONTAINER_ITEM_ID NUMBER

Master container item unique identifier. Both the master container item and container item organization are required to uniquely identify a master container item
CONTAINER_ITEM_ORG_NAME VARCHAR2 (60)
Organization name for the container item. Either the CONTAINER_ITEM_ORG_NAME, CONTAINER_ITEM_ORG_CODE or CONTAINER_ITEM_ORG_ID column needs to be populated to specify a container item organization
CONTAINER_ITEM_ORG_CODE VARCHAR2 (3)
Organization code for the container item. Either the CONTAINER_ITEM_ORG_NAME, CONTAINER_ITEM_ORG_CODE or CONTAINER_ITEM_ORG_ID column needs to be populated to specify a container item organization
CONTAINER_ITEM_ORG_ID NUMBER

Organization id for the container item. Either the CONTAINER_ITEM_ORG_NAME, CONTAINER_ITEM_ORG_CODE or CONTAINER_ITEM_ORG_ID column needs to be populated to specify a container item organization
DETAIL_CONTAINER_SEGMENT1 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT2 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT3 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT4 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT5 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT6 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT7 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT8 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT9 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT10 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT11 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT12 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT13 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT14 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT15 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT16 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT17 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT18 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT19 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER_SEGMENT20 VARCHAR2 (40)
Detail container item key flexfield segment
DETAIL_CONTAINER VARCHAR2 (2000)
Detail container item name (flexfield concatenated segments)
DETAIL_CONTAINER_ITEM_ID NUMBER

Detail container item identifier. Both the detail container item and container item organization are required to uniquely identify a detail container item
MIN_FILL_PERCENTAGE NUMBER

Minimum fill percentage
DEP_PLAN_REQUIRED_FLAG VARCHAR2 (1)
Flag indicating whether departure planning is required for thecustomer item
DEP_PLAN_PRIOR_BLD_FLAG VARCHAR2 (1)
Flag indicating if departure plan prior to build is required
INACTIVE_FLAG VARCHAR2 (1) Yes Flag indicating whether the customer item is inactive
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
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
DEMAND_TOLERANCE_POSITIVE NUMBER

Positive tolerance (high end) for customer item demand
DEMAND_TOLERANCE_NEGATIVE NUMBER

Negative tolerance (low end) for customer item demand
ERROR_CODE VARCHAR2 (9)
Populated with the error code of the latest error encountered by the interface while processing a row. Populated with Success if no errors were encounterd
ERROR_EXPLANATION VARCHAR2 (240)
Explanation of the error code
MASTER_CONTAINER_SEGMENT1 VARCHAR2 (40)
Master container item key flexfield segment
Query Text

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


SELECT PROCESS_FLAG
,      PROCESS_MODE
,      LOCK_FLAG
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TRANSACTION_TYPE
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_ID
,      CUSTOMER_CATEGORY_CODE
,      CUSTOMER_CATEGORY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      COUNTY
,      COUNTRY
,      POSTAL_CODE
,      ADDRESS_ID
,      CUSTOMER_ITEM_NUMBER
,      ITEM_DEFINITION_LEVEL_DESC
,      ITEM_DEFINITION_LEVEL
,      CUSTOMER_ITEM_DESC
,      MODEL_CUSTOMER_ITEM_NUMBER
,      MODEL_CUSTOMER_ITEM_ID
,      COMMODITY_CODE
,      COMMODITY_CODE_ID
,      MASTER_CONTAINER_SEGMENT2
,      MASTER_CONTAINER_SEGMENT3
,      MASTER_CONTAINER_SEGMENT4
,      MASTER_CONTAINER_SEGMENT5
,      MASTER_CONTAINER_SEGMENT6
,      MASTER_CONTAINER_SEGMENT7
,      MASTER_CONTAINER_SEGMENT8
,      MASTER_CONTAINER_SEGMENT9
,      MASTER_CONTAINER_SEGMENT10
,      MASTER_CONTAINER_SEGMENT11
,      MASTER_CONTAINER_SEGMENT12
,      MASTER_CONTAINER_SEGMENT13
,      MASTER_CONTAINER_SEGMENT14
,      MASTER_CONTAINER_SEGMENT15
,      MASTER_CONTAINER_SEGMENT16
,      MASTER_CONTAINER_SEGMENT17
,      MASTER_CONTAINER_SEGMENT18
,      MASTER_CONTAINER_SEGMENT19
,      MASTER_CONTAINER_SEGMENT20
,      MASTER_CONTAINER
,      MASTER_CONTAINER_ITEM_ID
,      CONTAINER_ITEM_ORG_NAME
,      CONTAINER_ITEM_ORG_CODE
,      CONTAINER_ITEM_ORG_ID
,      DETAIL_CONTAINER_SEGMENT1
,      DETAIL_CONTAINER_SEGMENT2
,      DETAIL_CONTAINER_SEGMENT3
,      DETAIL_CONTAINER_SEGMENT4
,      DETAIL_CONTAINER_SEGMENT5
,      DETAIL_CONTAINER_SEGMENT6
,      DETAIL_CONTAINER_SEGMENT7
,      DETAIL_CONTAINER_SEGMENT8
,      DETAIL_CONTAINER_SEGMENT9
,      DETAIL_CONTAINER_SEGMENT10
,      DETAIL_CONTAINER_SEGMENT11
,      DETAIL_CONTAINER_SEGMENT12
,      DETAIL_CONTAINER_SEGMENT13
,      DETAIL_CONTAINER_SEGMENT14
,      DETAIL_CONTAINER_SEGMENT15
,      DETAIL_CONTAINER_SEGMENT16
,      DETAIL_CONTAINER_SEGMENT17
,      DETAIL_CONTAINER_SEGMENT18
,      DETAIL_CONTAINER_SEGMENT19
,      DETAIL_CONTAINER_SEGMENT20
,      DETAIL_CONTAINER
,      DETAIL_CONTAINER_ITEM_ID
,      MIN_FILL_PERCENTAGE
,      DEP_PLAN_REQUIRED_FLAG
,      DEP_PLAN_PRIOR_BLD_FLAG
,      INACTIVE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DEMAND_TOLERANCE_POSITIVE
,      DEMAND_TOLERANCE_NEGATIVE
,      ERROR_CODE
,      ERROR_EXPLANATION
,      MASTER_CONTAINER_SEGMENT1
FROM INV.MTL_CI_INTERFACE;

Dependencies

[top of page]

INV.MTL_CI_INTERFACE does not reference any database object

INV.MTL_CI_INTERFACE is referenced by following:

SchemaAPPS
SynonymMTL_CI_INTERFACE