INV_PERFORM_PICK_TXNS_INT
INV_PERFORM_PICK_TXNS_INT is the gateway for WO pick confirm transactions. Typically, this table is used when WMS or 3PL send WO pick confirm transactions via the Oracle Integration Cloud (OIC) .
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
INV_PERFORM_PICK_TXNS_INT_PK |
TRANSACTION_INTERFACE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TRANSACTION_INTERFACE_ID | NUMBER | 18 | Yes | Interface identifier for the pick confirm transaction. | |
ORGANIZATION_ID | NUMBER | 18 | Identifies the inventory organization ID. | ||
ORGANIZATION_CODE | VARCHAR2 | 18 | Identifies the inventory organization code. | ||
INVENTORY_ITEM_ID | NUMBER | 18 | This identifies the inventory item. | ||
ITEM_NUMBER | VARCHAR2 | 300 | Identifies the product or material by name. | ||
REVISION | VARCHAR2 | 18 | Revision of the item when revision control is enabled. | ||
SOURCE_SUBINVENTORY_CODE | VARCHAR2 | 10 | Describes the source subinventory of the transaction. | ||
SOURCE_LOCATOR_ID | NUMBER | 18 | Indentifies the source locator ID of the transaction. | ||
SOURCE_LOCATOR_NAME | VARCHAR2 | 255 | Describes the source locator of the transaction. | ||
DEST_SUBINVENTORY_CODE | VARCHAR2 | 10 | Describes the destination subinventory of the transaction. | ||
DEST_LOCATOR_ID | NUMBER | 18 | Indentifies the destination locator ID of the transaction. | ||
DEST_LOCATOR_NAME | VARCHAR2 | 255 | Describes the destination locator of the transaction. | ||
PRIMARY_TRANSACTION_QUANTITY | NUMBER | Transaction quantity of the item's primary unit of measure. | |||
TRANSACTION_QUANTITY | NUMBER | Transaction quantity in the user's preferred unit of measure. | |||
TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Transaction unit of measure code. | ||
TRANSACTION_UOM_NAME | VARCHAR2 | 25 | Transaction unit of measure name. | ||
SECONDARY_TRANSACTION_QUANTITY | NUMBER | Secondary transaction quantity for the pick confirm transaction. | |||
SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary unit of measure code used for the pick confirm transaction. | ||
SECONDARY_UOM_NAME | VARCHAR2 | 25 | Secondary unit of measure name used for the pick confirm transaction. | ||
ALLOCATED_QUANTITY | NUMBER | Quantity allocated by the WMS or 3PL system. | |||
SHORT_QUANTITY | NUMBER | Quantity short-picked by the WMS or 3PL system. | |||
TRANSACTION_DATE | DATE | Indicates the date when the transaction was created. | |||
TRANSACTION_TYPE_ID | NUMBER | 18 | Identifies the transaction type. | ||
TRANSACTION_TYPE_NAME | VARCHAR2 | 80 | Identifies the transaction type by name. The values are based on the Transaction Type Name in INV_TRANSACTION_TYPES_TL. | ||
MOVE_ORDER_HEADER_ID | NUMBER | 18 | Identifies the Movement Request header by ID. | ||
MOVE_ORDER_HEADER_NUMBER | VARCHAR2 | 30 | Identifies the Movement Request header by number. | ||
MOVE_ORDER_LINE_ID | NUMBER | 18 | Movement Request line ID tied to this pick transaction line. | ||
MOVE_ORDER_LINE_NUMBER | NUMBER | 18 | Movement Request line number tied to this pick transaction line. | ||
EXT_SYS_GROUP_ID | NUMBER | 18 | Unique identifier to mark movement request headers that need to be interfaced to an external management system. | ||
SOURCE_CODE | VARCHAR2 | 30 | Transaction source code used for audit and process control. | ||
TRANSACTION_REFERENCE | VARCHAR2 | 240 | Reference code for the pick confirm transaction. | ||
EXTERNAL_SYS_TXN_REFERENCE | VARCHAR2 | 300 | Link to the transaction references passed by external WMS or 3PL systems. | ||
EXTERNAL_SYSTEM_PACKING_UNIT | VARCHAR2 | 150 | License plate number (LPN) of the external or third-party WMS. | ||
REASON_ID | NUMBER | 18 | Identifies the pick transaction reason by number. | ||
REASON_NAME | VARCHAR2 | 80 | Identifies the pick transaction reason by name. The values are based on the lookup type INV_REASON_TYPES in FND_LOOKUPS. | ||
STATUS_CODE | VARCHAR2 | 30 | Abbrevation that identifies the status of the pick transaction record. | ||
PROCESS_FLAG | VARCHAR2 | 1 | Flag that indicates whether to process the pick transaction record or not. | ||
ERROR_CODE | VARCHAR2 | 50 | Error message code that indicates the reason for the failure. | ||
ERROR_EXPLANATION | VARCHAR2 | 240 | Error message text that explains the reason for the failure. | ||
OWNING_TRADING_PARTNER_TYPE | VARCHAR2 | 30 | Owning type for the pick transaction record. | ||
OWNING_ORGANIZATION_ID | NUMBER | 18 | Owning organization identifier for the pick transaction record. | ||
OWNING_ORGANIZATION_CODE | VARCHAR2 | 18 | Owning organization code for the pick transaction record. | ||
PRC_BU_NAME | VARCHAR2 | 240 | Procuring business unit for the pick transaction record when there's a consigned quantity. | ||
VENDOR_NAME | VARCHAR2 | 240 | Vendor name for the pick transaction record when there's a consigned quantity. | ||
VENDOR_NUMBER | VARCHAR2 | 20 | Vendor number for the pick transaction record when there's a consigned quantity. | ||
CONSIGNMENT_AGREEMENT_NUM | VARCHAR2 | 30 | Consignment agreement number for the consigned material. This column is populated if the the Vendor Name, Vendor Number, Procurement Business Unit, or Vendor Site Code is insufficient to derive the Vendor Site ID. | ||
INV_STRIPING_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for inventory striping attributes. | ||
PROJECT_ID | NUMBER | 18 | Identifies the project used to stripe pick transactions. | ||
INV_PROJECT | VARCHAR2 | 25 | Name of the project used to stripe pick transactions. | ||
TASK_ID | NUMBER | 18 | Identifies the task used to stripe pick transactions. | ||
INV_TASK | VARCHAR2 | 100 | Name of the task used to stripe pick transactions. | ||
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of the manufacturer. | ||
COUNTRY_OF_ORIGIN_NAME | VARCHAR2 | 80 | Name for the country of the manufacturer used to stripe pick transactions. | ||
INV_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future functionality related to inventory striping. | ||
INV_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future functionality related to inventory striping. | ||
INV_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-defined inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-defined inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-defined inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-defined inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-defined inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-defined inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-defined inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-defined inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-defined inventory striping information. | ||
INV_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-defined inventory striping information. | ||
LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
LOAD_REQUEST_ID | NUMBER | 18 | Used by Enterprise Service Scheduler. Indicates the request ID of the interface job that created the row. | ||
INV_LOT_SERIAL_NUM | VARCHAR2 | 30 | Lot serial interface number. Used for sequencing in SAAS Processing. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
TXN_INTERFACE_GROUP_ID | NUMBER | 18 | Transaction interface group identifier for the pick confirm transactions. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
INV_PERFORM_PICK_TXNS_INT_N1 | Non Unique | FUSION_TS_INTERFACE | ORGANIZATION_ID, STATUS_CODE, LOAD_REQUEST_ID |
INV_PERFORM_PICK_TXNS_INT_N2 | Non Unique | FUSION_TS_INTERFACE | INV_LOT_SERIAL_NUM |
INV_PERFORM_PICK_TXNS_INT_N3 | Non Unique | FUSION_TS_INTERFACE | EXTERNAL_SYS_TXN_REFERENCE |
INV_PERFORM_PICK_TXNS_INT_N4 | Non Unique | FUSION_TS_INTERFACE | TXN_INTERFACE_GROUP_ID |
INV_PERFORM_PICK_TXNS_INT_N5 | Non Unique | FUSION_TS_INTERFACE | ORGANIZATION_CODE |
INV_PERFORM_PICK_TXNS_INT_U1 | Unique | FUSION_TS_INTERFACE | TRANSACTION_INTERFACE_ID |