RecallNoticesV2
RecallNoticesV2
Columns
| Name | Type | Description |
| HeaderId [KEY] | Long | Value that uniquely identifies the recall notice header. |
| RecallNoticeNumber | String | Number that identifies the recall notice. This attribute is used for internal tracking within the enterprise and gets generated based on the document sequencing setup. |
| BusinessUnitId | Long | Value that uniquely identifies the business unit in which the recall notice is created. |
| BusinessUnitName | String | Name of the business unit. |
| DupValidationFlag | Bool | Contains one of the following values: true or false. If true, then duplication validation has happened. If false, then duplication validation hasn't happened. The default value is false. |
| LocateStatus | String | Contains one of the following values: true or false. If true, then locate action has been taken on the recall notice. If false, then locate action hasn't been taken on the recall notice. The default value is false. |
| ManufacturerId | Long | Value that uniquely identifies the trading partner. |
| BpaManufacturerLineId | Long | Value that uniquely identifies the blanket purchase order line defined in the recall notice header. |
| RecallingFirm | String | Attribute that identifies the recalling firm that initiated the recall. |
| ManufacturerNumber | String | Manufacturer Number |
| ModeOfCaptureCode | String | Value that indicates the code related to the mode of capture of a reall notice. |
| ModeOfCapture | String | Value that indicates the mode of capture of a recall notice. A list of accepted values is defined in the lookup type ORA_SCH_PRM_MODE_OF_CAPTURE. It identifies the meaning of FND_LOOKUP. |
| RecallReceivedFrom | String | Attribute that identifies the entity that initiated the recall notice. |
| AdditionalInformation | String | Additional information related to the recall notice header. |
| VendorId | Long | Value that uniquely identifies theSupplier. |
| RecallClosedDate | Datetime | Indicates the date of closure of the recall notice. |
| RelatedLinks | String | Value that provides the URL information provided in the recall notice. |
| ObjectVersionNumber | Int | Number that identifies the object version. This attribute is used for optimistic locking. The number is incremented every time 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. |
| OriginalHeaderId | Long | Value that uniquely identifies the original recall notice header that gets updated for a recall notice marked as duplicate. |
| PotentialRisk | String | Text that provides details about the risk factors of the recalled product. |
| RecallClassificationTypeCode | String | Abbreviation that identifies the classification of a recall notice based on the severity of impact it has on consumers. A list of accepted values is defined in the lookup type ORA_SCH_CLASSIFICATION. |
| RecallClassificationType | String | Classification of recall notice based on the severity of impact it has on consumers. A list of accepted values is defined in the lookup type ORA_SCH_CLASSIFICATION. It identifies the meaning of FND_LOOKUP. |
| RecallNoticeTypeCode | String | Abbreviation that identifies the classification of a recall notice. A list of accepted values is defined in the lookup type ORA_SCH_NOTICE_TYPE. |
| RecallNoticeType | String | Classification of the recall notice. A list of accepted values is defined in the lookup type ORA_SCH_NOTICE_TYPE. It identifies the meaning of FND_LOOKUP. |
| RecallSourceTypeCode | String | Abbreviation that identifies the type of source that initiated the recall. Values include Manufacturer, Regulatory Authority, and so on. |
| RecallSourceType | String | Type of source that initiated the recall. Values include Manufacturer, Regulatory Authority, and so on. It identifies the meaning of FND_LOOKUP. |
| RecallHeaderStatusCode | String | Value that identifies the status of the recall notice header. A list of accepted values is defined in the lookup type ORA_SCH_RECALL_HEADER_STATUS. It identifies the meaning of FND_LOOKUP. |
| RecallHeaderStatus | String | Status of the recall notice header. It identifies the meaning of FND_LOOKUP. |
| ReplacementTypeCode | String | Abbreviation that identifies the type of method by which the recalled parts can be disposed off. A list of accepted values is defined in the lookup type ORA_SCH_REPLACEMENT_TYPE. |
| ReplacementType | String | Type of method by which the recalled parts can be disposed off. A list of accepted values is defined in the lookup type ORA_SCH_REPLACEMENT_TYPE. It identifies the meaning of FND_LOOKUP. |
| RecallClosingDate | Datetime | The date on which the recall notice status was updated to Pending Closure. |
| RecallInitiationDate | Date | Indicates the initiation date of the recall notice by the source. |
| RecallInstruction | String | Text that provides special instructions on taking disposition actions for recalled parts. |
| RecallReason | String | Text that provides details about the recall reasons. |
| SourceReferenceNumber | String | Number that references the recall. This value is provided by the source that initiated the recall. |
| CreatedBy | String | User who created the record. |
| CreationDate | Datetime | Date and time when the user created the record. |
| LastUpdateDate | Datetime | Date and time when the user most recently updated the record. |
| LastUpdatedBy | String | User who most recently updated the record. |
| LastUpdateLogin | String | Login that the user used when updating the record. |
| RecallTrackStartDate | Date | Date when the recall track starts. This attribute is used to locate the part that's not associated with a batch or serial. |
| RecallTrackEndDate | Date | Date when the recall track ends. This attribute is used to locate the part that's not associated with a batch or serial. |
| Comments | String | Comments on the withdrawal of a recall notice. |
| ExternalSourceHeaderId | Long | Unique identifier of the external source header of the recall notice. |
| NumberOfLinesFound | String | Number of line items located in a recall notice. |
| NumberOfLinesInProgress | String | Number of line items in the in-progress status for a recall notice. |
| NumberOfLinesClosed | String | Number of line items in the closed status for a recall notice. |
| TasksAssigned | Decimal | Value that identifies the total number of assigned tasks. |
| TraceabilityStatusFound | Decimal | Value that identifies the number of distinct traceability statuses found. |
| TasksCompleted | Decimal | Value that identifies the percentage of the tasks in completed and withdrawn status to the total number of tasks in a recall notice. |
| ItemsNotFoundFlag | Bool | Contains one of the following values: true or false. If true, then locate couldn't trace the part. If false, then locate traced the part. The default value is true. |
| IsWithdrawEligibleFlag | Bool | Contains one of the following values: true or false. If true, then the recall notice is eligible for withdrawal. If false, then the recall notice isn't eligible for withdrawal. The value is derived, so it doesn't have a default value. |
| TotalTraceabilityStatus | Long | Total number of distinct traceability statuses that exist. |
| TotalTasksCompleted | Long | Total number of tasks in completed and withdrawn status in a recall notice. |
| LocateRequestId | Long | Value that uniquely identifies the locate request. This attribute is application generated when the locate parts job is submitted. |
| TrackStartDate | Date | Date when the recall track starts. This attribute is entered by the user when submitting the job for locate parts. |
| TrackEndDate | Date | Date when the recall track ends. This attribute is entered by the user when submitting the job for locate parts. |
| AttachmentEntityName | String | Name of the attachment entity. |
| TotalNoOfLines | String | Indicates the total number of lines in a recall notice. |
| BypassTaskFlag | Bool | Value that indicates if the recall count and disposal tasks can be skipped for a recall notice. |
| SourceRecallingFirm | String | Value that identifies the name of the manufacturer or supplier who initiated the recall. |
| RecallReportDate | Date | Indicates the date on which the recall notification is originally reported. |
| RecallDeviceClassCode | String | Code related to the device class of a recall notice. |
| RecallDeviceClass | String | Indicates the risk based classification system for all medical devices. |
| WithdrawReasonCode | String | Lookup code selected as the reason for withdrawing a recall notice that's in Open status. The lookup codes are user-defined. |
| WithdrawReason | String | Lookup meaning selected to withdraw a recall notice that's in Open status. The lookup codes are user-defined. |
| RelevantLinesCount | Long | Total number of recall lines that aren't withdrawn and have an item, manufacturer part number, or supplier part number. |
| ProviderRecallAssociationNumber | String | Original provider recall number passed by the provider in the subsequent recall notice to make any revision to the existing recall data. |
| ProviderRecallNumber | String | Unique recall number passed by the provider. |
| RecallAssociationId | Long | Original recall header identifier in the expansion recall notice to indicate that it's an expansion recall. |
| RecallAssociationNumber | String | Original source document reference number passed in the expansion recall notice to indicate that it's an expansion recall. |
| ExpansionNoticesCount | String | Count of expansion recalls for a parent recall notice. |
| BindItemDesc | String | Description of the item used for item lookup; used by the searchByItemDesc finder to locate matching items. |
| Finder | String | Search text used by the finder to locate records (helper attribute for client-side search functionality). |