RecallNoticesV2recallLines

Columns


Name	Type	Description
RecallNoticesV2HeaderId [KEY]	Long	Value that uniquely identifies the recall notice header.
LineId [KEY]	Long	Value that uniquely identifies the recall notice line.
HeaderId	Long	Value that uniquely identifies the recall notice header.
LineNumber	Long	Number that identifies the recall notice line entered by the user.
BrandName	String	Value that indicates the brand name for the recalled product.
ManufacturerPartId	Long	Value that uniquely identifies the trading partner item.
BpaManufacturerPartLineId	Long	Value that uniquely identifies the blanket purchase order line defined in the recall line.
ManufacturerPartNumber	String	Number that identifies the manufacturer part in the recall line.
ItemValidationOrgId	Long	Value that uniquely identifies the item validation organization.
InventoryItemId	Long	Value that uniquely identifies the inventory item.
ItemNumber	String	Number that identifies the item.
ItemDescription	String	Description of the item as a statement, picture description, or an account description.
PrimaryUnitOfMeasure	String	Value that identifies the primary unit of measure of the item.
ItemCategoryId	String	Value that uniquely identifies the purchasing item category.
CategoryName	String	Value that identifies the name of the item category.
ModelName	String	Model name of the recalled product.
NdcCode	String	Abbreviation that identifies the national drug for the recalled part.
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.
OriginalLineId	Long	Value that uniquely identifies the original recall notice line that gets updated for a recall notice line marked as duplicate.
RecallLineStatusCode	String	Abbreviation that identifies the status of recall line. It identifies the code for FND_LOOKUP.
RecallLineStatus	String	Status of recall notice line.
RecallClosingDate	Datetime	Date when the expected recall notice closes.
Comments	String	Comments on withdrawal of a recall line.
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	Name of the user who most recently updated the record.
LastUpdateLogin	String	User who most recently updated the record.
SupplierPartNumber	String	Supplier part number.
ProductDescription	String	Value that identifies the description of the product.
GTIN	String	Indicates the Global Trade Identification number provided in the recall notification.
UDI	String	Indicates the Unique Device Identifier provided in the recall notification.
PartNumber	String	Part number.
AdditionalInformation	String	Additional information related to the recall notice line.
ProductTypeCode	String	Value that identifies the recalled product type code. A list of accepted values is defined in the lookup type ORA_SCH_PRM_PRODUCT_TYPES. It identifies the meaning of FND_LOOKUP.
ProductType	String	Value that identifies the recalled product type.
ExpectedQuantity	Decimal	Quantity of recalled items expected in the PAR, EXPENSE, and IN_STOCK status for a given line.
InboundQuantity	Decimal	Quantity of recalled items in the INBOUND status for a given line.
CountQuantity	Decimal	Count of the recalled item quantities for a given line.
TotalNumberOfLots	Long	Total number of lots for a line.
TasksCompleted	Long	Value that identifies the percentage of tasks in completed and withdrawn status to the total number of tasks for a recall line.
ParExpectedQuantity	Decimal	Count of the recalled item quantities in the PAR status for a given line.
ExpenseExpectedQuantity	Decimal	Quantity of recalled items expected in the EXPENSE status for a given line.
InStockEstimatedQuantity	Decimal	Quantity of recalled items expected in the IN STOCK status for a given line.
InBoundEstimatedQuantity	Decimal	Quantity of recalled items expected in the IN BOUND status for a given line.
InStockCountedQuantity	Decimal	Count of the recalled item quantities in the IN STOCK status for a given line.
ParCountedQuanity	Decimal	Count of the recalled item quantities in the PAR status for a given line.
ExpenseCountedQuantity	Decimal	Count of the recalled item quantities in the EXPENSE status for a given line.
DisposedQuantity	Decimal	Quantity of recalled items disposed for a given line.
ControlType	String	Value that identifies whether the line is lot, serial, or lot and serial controlled.
SerialEntryMode	String	Value that identifies whether the line has a serial controlled item.
AttachmentEntityName	String	Name of the attachment entity.
TotalNumberOfAttachments	Long	Indicates the total number of attachments.
TotalSerialsQuantity	Long	Total quantity of recalled serial numbers.
ExternalSourceLineId	Long	Value that uniquely identifies the recall line.
WithdrawReasonCode	String	Lookup code selected to specify the reason for withdrawing a recall line that's in Open status. The lookup codes are user-defined.
WithdrawReason	String	Lookup meaning selected to withdraw a recall line that's in Open status. The lookup codes are user-defined.
ProviderLineNumber	String	Unique recall line number passed by the provider.
ProbableMatchesFoundFlag	Bool	Indicates whether an exact item match exists or probable match exists for the recalled parts in the recall notice.
InvokedFrom	String	Source context from which this recall line was invoked (used internally to track origin of operation).
BindItemDesc	String	Item description used for lookup; used by the searchByItemDesc finder to locate matching items.
Finder	String	Search text used by the client-side finder to locate records (helper attribute for search operations).

ODBC Driver for Oracle Fusion Cloud SCM

RecallNoticesV2recallLines

Columns