SCH_REC_BYPASS_TASKS

Details

Schema: FUSION
Object owner: SCH
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
SCH_REC_BYPASS_TASK_HISTORY_PK	BYPASS_TASK_HISTORY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BYPASS_TASK_HISTORY_ID	NUMBER		18	Yes	Unique identifier for the bypass task generated for a recall notice line in the Bypass Count and Disposal Tasks workflow.
RECALL_HEADER_ID	NUMBER		18	Yes	Recall Notice Header unique identifier.
RECALL_LINE_ID	NUMBER		18	Yes	Recall Notice Line unique identifier.
INVENTORY_ITEM_ID	NUMBER		18		Unique identifier of the Master Item that is recalled.
MANUFACTURER_PART_NUMBER	VARCHAR2	700			Manufacturer part number that is recalled.
VENDOR_PRODUCT_NUM	VARCHAR2	300			Supplier part number that is recalled.
ORGANIZATION_ID	NUMBER		18	Yes	Unique identifier of the inventory organization in which the bypass task is generated.
MATERIAL_STATUS	VARCHAR2	30			Status of the recalled parts indicating whether they are in transit or already received in the facility.
RECALL_ACTION	VARCHAR2	30			Reason code that describes the containment action taken on the recalled part in an organization.
COMMENTS	VARCHAR2	4000			Comments provided by the user while completing the bypass task.
BYPASS_TASK_STATUS	VARCHAR2	30		Yes	Indicates the status of the bypass task, whether it is in progress or completed. The status values retrieved from the seeded lookup type ORA_SCH_BYPASS_TASK_STATUS are INPROGRESS, COMPLETED.
COMPLETION_DATE	TIMESTAMP				Indicates the date on which the bypass task is completed.
RESPONSE_REQUIRED_FLAG	VARCHAR2	1			Indicates whether response is required for the bypass task to close a recall.
SUBINVENTORY	VARCHAR2	60			Indicates the subinventory where the recalled part resides and for which the bypass task is generated. This value is populated only when the task grouping is set to Subinventory in the recall parameters.
LOCATION_ID	NUMBER		18		Location identifier where the recalled part resides and for which the bypass task is generated. This value is populated only when the task grouping is set to Location in the recall parameters.
COST_CENTER_NUMBER	VARCHAR2	250			Number of the cost center which has received the recalled parts and for which the bypass task is generated.
INSTRUCTIONS	VARCHAR2	4000			Containment instructions provided to the responder who performs the containment action and complete the bypass tasks.
DISPOSITION_QUANTITY	NUMBER				Quantity quarantined and disposed against a bypass task.
COST_CENTER_DESCRIPTION	VARCHAR2	1000			Description of the cost center which has received the recalled parts and for which the bypass task is generated.
TASK_COMPLETED_BY	VARCHAR2	250			Indicates the user who completed the bypass task.
NOTIFICATION_GROUP_ID	NUMBER		18		Unique identifier to group the bypass tasks to send notifications.
MODE_OF_CREATION	VARCHAR2	64			Method by which the bypass task is created. It can have the following values: Manual, System Generated.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of 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.

Indexes

Index	Uniqueness	Tablespace	Columns
SCH_REC_BYPASS_TASK_HISTORY_N1	Non Unique	Default	NOTIFICATION_GROUP_ID, RECALL_HEADER_ID
SCH_REC_BYPASS_TASK_HISTORY_U1	Unique	Default	BYPASS_TASK_HISTORY_ID