Requisition Lines

The Requisition Lines view object stores information about requisition lines. It manages the items to be purchased, its quantity, unit of measure, price, and deliver-to location information.

Data Store Key : FscmTopModelAM.PrcExtractAM.PorBiccExtractAM.RequisitionLineExtractPVO

Primary Keys : RequisitionLineId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ActionRequiredCode	Value that identifies the action required of the user to remove the invoice hold on the line's corresponding invoice.
AdditionalContactEmail	Email addresses of additional supplier contacts. These email addresses are used to send purchase orders to supplier contacts involved in the procurement process.
Amount	Total amount of the requested items in the currency of the buying company.
AssessableValue	Value that's assessable.
AssignedBuyerId	Value that uniquely identifies the person responsible for managing the purchase requisition through its life cycle.
AtSourcingFlag	Contains one of the following values: Y, N, or NULL. If Y, then the requisition line is part of an active negotiation in Oracle Sourcing. If N or NULL, then the requisition line isn't part of an active negotiation in Oracle Sourcing.
Attribute1	Segment for the Requisition Line descriptive flexfield.
Attribute10	Segment for the Requisition Line descriptive flexfield.
Attribute11	Segment for the Requisition Line descriptive flexfield.
Attribute12	Segment for the Requisition Line descriptive flexfield.
Attribute13	Segment for the Requisition Line descriptive flexfield.
Attribute14	Segment for the Requisition Line descriptive flexfield.
Attribute15	Segment for the Requisition Line descriptive flexfield.
Attribute16	Segment for the Requisition Line descriptive flexfield.
Attribute17	Segment for the Requisition Line descriptive flexfield.
Attribute18	Segment for the Requisition Line descriptive flexfield.
Attribute19	Segment for the Requisition Line descriptive flexfield.
Attribute2	Segment for the Requisition Line descriptive flexfield.
Attribute20	Segment for the Requisition Line descriptive flexfield.
Attribute3	Segment for the Requisition Line descriptive flexfield.
Attribute4	Segment for the Requisition Line descriptive flexfield.
Attribute5	Segment for the Requisition Line descriptive flexfield.
Attribute6	Segment for the Requisition Line descriptive flexfield.
Attribute7	Segment for the Requisition Line descriptive flexfield.
Attribute8	Segment for the Requisition Line descriptive flexfield.
Attribute9	Segment for the Requisition Line descriptive flexfield.
AttributeCategory	Context name for the Requisition Line descriptive flexfield.
AttributeDate1	Date segment for the Requisition Line descriptive flexfield.
AttributeDate10	Date segment for the Requisition Line descriptive flexfield.
AttributeDate2	Date segment for the Requisition Line descriptive flexfield.
AttributeDate3	Date segment for the Requisition Line descriptive flexfield.
AttributeDate4	Date segment for the Requisition Line descriptive flexfield.
AttributeDate5	Date segment for the Requisition Line descriptive flexfield.
AttributeDate6	Date segment for the Requisition Line descriptive flexfield.
AttributeDate7	Date segment for the Requisition Line descriptive flexfield.
AttributeDate8	Date segment for the Requisition Line descriptive flexfield.
AttributeDate9	Date segment for the Requisition Line descriptive flexfield.
AttributeNumber1	Number segment for the Requisition Line descriptive flexfield.
AttributeNumber10	Number segment for the Requisition Line descriptive flexfield.
AttributeNumber2	Number segment for the Requisition Line descriptive flexfield.
AttributeNumber3	Number segment for the Requisition Line descriptive flexfield.
AttributeNumber4	Number segment for the Requisition Line descriptive flexfield.
AttributeNumber5	Number segment for the Requisition Line descriptive flexfield.
AttributeNumber6	Number segment for the Requisition Line descriptive flexfield.
AttributeNumber7	Number segment for the Requisition Line descriptive flexfield.
AttributeNumber8	Number segment for the Requisition Line descriptive flexfield.
AttributeNumber9	Number segment for the Requisition Line descriptive flexfield.
AttributeTimestamp1	Date and time segment for the Requisition Line descriptive flexfield.
AttributeTimestamp10	Date and time segment for the Requisition Line descriptive flexfield.
AttributeTimestamp2	Date and time segment for the Requisition Line descriptive flexfield.
AttributeTimestamp3	Date and time segment for the Requisition Line descriptive flexfield.
AttributeTimestamp4	Date and time segment for the Requisition Line descriptive flexfield.
AttributeTimestamp5	Date and time segment for the Requisition Line descriptive flexfield.
AttributeTimestamp6	Date and time segment for the Requisition Line descriptive flexfield.
AttributeTimestamp7	Date and time segment for the Requisition Line descriptive flexfield.
AttributeTimestamp8	Date and time segment for the Requisition Line descriptive flexfield.
AttributeTimestamp9	Date and time segment for the Requisition Line descriptive flexfield.
AuctionDisplayNumber	Display number of the auction document.
AuctionHeaderId	Value that uniquely identifies the auction document used in sourcing.
AuctionLineNumber	Line number on the auction document.
BackToBackFlag	Contains one of the following values: true or false. If true, then the purchase requisition line is intended to fulfill a specific customer sales order upon receipt. If false, then the purchase requisition line doesn't have a backing sales order. This attribute doesn't have a default value.
BaseModelId	Value that uniquely identifies the part number used by the buying organization to identify the Base or ATO Model on which the unique configuration is built. This part number is defined in PIM.
BaseModelPrice	Unit price of the base model only.
BidLineNumber	Sourcing bid line number.
BidNumber	Sourcing bid number.
BpaPriceUserOverrideFlag	Indicates whether the blanket purchase agreement price attribute has been updated by user.
BuyerProcessingFlag	Indicates whether the buyer is currently working on the requisition line or not.
CancelDate	Date when the requested items were canceled.
CancelFlag	Indicates whether the requisition line is canceled or not.
CancelReason	Reason for canceling the requested items.
CarrierId	Value that uniquely identifies the company that transports goods from one point to another by land, sea, or air.
CategoryId	Value that uniquely identifies the purchasing category.
CategoryId1	Value that uniquely identifies the purchasing category.
CategoryName	Name of the purchasing category that's used for classifying the purchase being made by using this order line.
ConfiguredItemFlag	Contains one of the following values: true or false. If true, then the requisition line is for a configured item and configuration details might exist. If false, then the requisition line isn't for a configured item. This attribute doesn't have a default value.
ContentPrcBuId	Value that uniquely identifies the business unit of the content.
CreatedBy	User who created the requisition line.
CreationDate	Date and time when the requisition line was created.
CurrencyAmount	Total amount of the requested item in the currency of the supplier.
CurrencyCode	Code that identifies the purchase requisition currency.
CurrencyUnitPrice	Unit price in foreign currency.
CustomerItem	Alternate key for the internal item used by customers to uniquely identify the item.
CustomerItemDesc	Description of the item identifier used by customers.
CustomerPoLineNumber	Number that uniquely identifies the customer PO line record. The customer PO line describes an item or service requested by the end customer.
CustomerPoNumber	Customer PO number on the Sales Order. PO number reference that represents the commercial document that's used to request a seller to supply a product or service in return for payment.
CustomerPoScheduleNumber	Number that uniquely identifies the customer PO schedule record. The customer PO schedule describes an item or service requested by the end customer.
DaysEarlyReceiptAllowed	Maximum acceptable number of days allowed for early receipts.
DaysLateReceiptAllowed	Maximum acceptable number of days allowed for late receipts.
DefaultTaxationCountry	Default country used for taxation purposes.
DeliverToCustContactId	Unique identifier of the contact from the company where the goods are being delivered.
DeliverToCustId	Value that uniquely identifies the customer to whom merchandise is being delivered.
DeliverToCustLocationId	Value that uniquely identifies the final location where goods will be delivered that were previously received from a supplier.
DeliverToLocationId	Value that uniquely identifies the final location where the buying company should deliver the goods previously received from a supplier.
DestinationOrganizationId	Value that uniquely identifies the inventory organization where the supplier should deliver the goods.
DestinationSubinventory	Name of the subinventory that identifies where to deliver the requested item.
DestinationTypeCode	Code that identifies whether the item is for inventory, expense, drop ship, or manufacturing. Valid values include INVENTORY, EXPENSE, DROP SHIP, and MANUFACTURING.
DocumentSubType	Subtype of the document.
EffectiveEndDate	Date at which the specific location data is no longer effective.
EffectiveEndDate1	Date at which the specific person name is no longer effective.
EffectiveStartDate	Date at which the specific location data becomes effective.
EffectiveStartDate1	Date at which the specific person name becomes effective.
ExternalCategoryValue	Category retrieved from punchout cart in case of a punchout line.
ExternalUomQuantity	UOM associated quantity retrieved from punchout cart in case of a punchout line.
ExternalUomValue	UOM retrieved from punchout cart in case of a punchout line.
FinalDischargeLocationId	Value that uniquely identifies the final destination location for the purchases made by the customer. The location of the final customer or where the goods would be used isn't necessarily the same as the initial ship-to location.
FirmFlag	Indicates whether planning can reschedule or cancel the purchase order schedule.
FirstPtyRegId	Value that uniquely identifies the first party registration. This value is assigned to a first party by a tax authority when it's registered.
FundsStatus	Status of the funds reservation request.
HazardClassId	Value that uniquely identifies the hazard class captured on the line to comply with Section 19 of the International Safety Rating System.
InfoTemplateTouchedFlag	Indicates whether the user has opened an information template or not.
InterfaceLineKey	Value that identifies the row in the requisition lines interface table.
InventoryItemId	Value that uniquely identifies the item being purchased.
ItemDescription	Description of the goods or services being purchased.
ItemId	Value that uniquely identifies the item being purchased.
ItemNumber	Number that uniquely identifies the item.
ItemRevision	Number that identifies the revision of the item.
ItemSource	Source of the item. It indicates whether item comes from catalog, noncatalog, quick create, punchout, requisition import or service.
ItemUserOverrideFlag	Indicates whether item attributes have been updated by the user.
JobDefinitionName	Name of the job that created or last updated the row.
JobDefinitionPackage	Package name of the job that created or last updated the row.
LastApprovalDate	Date when the requisition lines was last approved.
LastSubmittedDate	Date when the requisition line was last submitted for approval.
LastUpdateDate	Date and time when the requisition was last updated.
LastUpdateLogin	Session login associated with the user who last updated the row.
LastUpdatedBy	Name of the user who last updated the requisition.
LifecycleStatus	Value that identifies the lifecycle status code of the requisition line.
LineGroup	Group that indicates which group filter a requisition line belongs to.
LineIntendedUse	Intended Use of the item being purchased. For example, manufacturing, consumption, or maintenance.
LineIntendedUseId	Value that uniquely identifies the Intended Use ID.
LineLocationId	Value that uniquely identifies the document shipment schedule.
LineNumber	Number that uniquely identifies the line associated with a purchase requisition.
LineStatus	Status of the requisition line.
LineTypeId	Value that indicates whether a purchase requisition line is for goods or services.
ListName	List name format of a person's name. The list name format for US English is Prefix, LastName or Preferred Name, FirstName. For examples, Jones, Bob or de la Cruz, Martin.
LocationId	Value that uniquely identifies the Deliver-to location.
LocationName	Name of the Deliver-to location.
ManufacturerName	Name of the company that manufactures the item being purchased.
ManufacturerPartNumber	Number that uniquely identifies the item as provided by the manufacturer.
MatchingBasis	Basis of matching of the line type.
ModeOfTransport	Mode of transportation used to ship the product such as truck, air, or boat.
ModifiedByBuyerFlag	Indicates whether the line has been modified by the buyer.
ModifiedByBuyerId	Value that uniquely identifies the buyer who modified the requisition line by splitting the requisition line or by replacing the requested item with a catalog item.
NeedByDate	Date the user wants the item.
NegotiatedByPreparerFlag	Contains one of the following values: true or false. If true, then the price on the purchase requisition line is agreed on in advance between the buying company and the supplier. If false, then the price isn't agreed on in advance. This attribute doesn't have a default value.
NegotiationRequiredFlag	Contains one of the following values: true or false. If true, then an request for quotation is required prior to placing the requisition line on a purchase order. If false, then an request for quotation isn't required. This attribute doesn't have a default value.
NewSupplierFlag	Contains one of the following values: true or false. If true, then the supplier entered on the line is a new supplier. If false, then the supplier entered on the line is an existing supplier. This attribute doesn't have a default value.
NoteToBuyer	Note to the buyer on the purchase requisition.
NoteToReceiver	Note to the receiver on the purchase requisition.
NoteToSupplier	Note to the supplier on the purchase requisition.
ObjectVersionNumber	Indicates the version number of the requisition line row.
ObjectVersionNumber1	Indicates the version number of the requisition line row.
ObjectVersionNumber2	Indicates the version number of the requisition line row.
OnRfqFlag	Indicates whether the requisition line was placed on an RFQ.
OneTimeLocationFlag	Contains one of the following values: true or false. If true, then the location on final delivery of goods is a one time delivery address. If false, then the location of delivery is an existing address in Oracle Global Human Resources Cloud. The default value is false.
OptionsPrice	Price that indicates the sum of the extended price of all options chosen per unit of the purchased configuration.
OrchestrationCode	Code for integrating applications to determine the transactions within Procurement that they need to track. For example, SCO and DOO.
OrderTypeLookupCode	Code that identifies the type of the order.
OrganizationId	Value that uniquely identifies the organization associated with an item.
OriginalApprovalDate	Date when the requisition line was first approved.
OriginalSubmittedDate	Date when the requisition line was first submitted for approval.
ParentReqLineId	Value that uniquely identifies the parent requisition line for a modified requisition line.
PcardFlag	Indicate whether the line was ordered using a procurement card.
PersonNameId	Value that uniquely identifies the requester on the line.
PoHeaderId	Value that uniquely identifies the purchase order.
PoLineId	Value that uniquely identifies the parent purchase order line.
PrcBuId	Value that uniquely identifies the procurement business unit.
PriceVarianceExceededAmt	Price variance amount of the requisition line if the punchout item exceeds the price variance check.
PriceVarianceExceededFlag	Indicate whether the punchout requisition line exceeded the price variance check as per the tolerance on the punchout catalog.
ProductCategory	Category of the product.
ProductFiscClassification	Fiscal Classification of the product.
ProductFiscClassificationId	Value that uniquely identifies the Product Fiscal Classification Id.
ProductType	Type of the product.
PublicListId	Value that uniquely identifies the public list from which the item was added to the requisition line.
PunchoutCatalogId	Value that uniquely identifies the punchout.
PurchaseBasis	Purchase basis of the line type.
QtyRcvTolerance	Percentage of the quantity that can be received in excess of the designated order quantity.
Quantity	Quantity of the goods being purchased.
Rate	Rate of the currency conversion.
RateDate	Date of the currency conversion rate.
RateType	Type of the currency conversion rate.
ReceiptCloseTolerancePercent	Value that indicates the percentage that the application uses to determine whether to automatically close a purchase order schedule when the receiver receives only part of the item.
ReinstateLineLocationId	Value that uniquely identifies the document shipment schedule from which the requisition line was reinstated.
RepriceFlag	Indicate whether the transfer supply request can be repriced by calling Supply Chain Financial Orchestration.
ReqBuId	Value that uniquely identifies the requisitioning business unit.
ReqPoInstanceId	Value that uniquely identifies an instance of the requisition to PO automation in BPEL.
ReqsInPoolFlag	Indicate whether the requisitions are available for buyer to take action on such as to create a PO.
ReqtopoAutoFailedReason	Reason for requisition to PO automation failure where the failure was due to a functional error.
ReqtopoAutomationFailed	Indicate whether the requisition to PO automation failed or not.
RequestId	Value that uniquely identifies the request ID of the job that created or last updated the row. This is used in Enterprise Service Scheduler.
RequestedShipDate	Date when the buying company requested the ordered item to be shipped.
RequesterId	Value that uniquely identifies the person for whom goods or services are being ordered.
RequesterSupervisorLevel1	Level 1 supervisor of the requester, where level 1 is the highest management level of the organization.
RequesterSupervisorLevel10	Level 10 supervisor of the requester, where level 1 is the highest management level of the organization.
RequesterSupervisorLevel2	Level 2 supervisor of the requester, where level 1 is the highest management level of the organization.
RequesterSupervisorLevel3	Level 3 supervisor of the requester, where level 1 is the highest management level of the organization.
RequesterSupervisorLevel4	Level 4 supervisor of the requester, where level 1 is the highest management level of the organization.
RequesterSupervisorLevel5	Level 5 supervisor of the requester, where level 1 is the highest management level of the organization.
RequesterSupervisorLevel6	Level 6 supervisor of the requester, where level 1 is the highest management level of the organization.
RequesterSupervisorLevel7	Level 7 supervisor of the requester, where level 1 is the highest management level of the organization.
RequesterSupervisorLevel8	Level 8 supervisor of the requester, where level 1 is the highest management level of the organization.
RequesterSupervisorLevel9	Level 9 supervisor of the requester, where level 1 is the highest management level of the organization.
RequisitionHeaderId	Value that uniquely identifies the requisition.
RequisitionLineId	Value that uniquely identifies the requisition line.
SalesOrderLineNumber	Number that uniquely identifies the sales order line for a given customer sales order.
SalesOrderNumber	Number that uniquely identifies the backing sales order
SalesOrderScheduleNumber	Number that uniquely identifies the sales order schedule for a given customer sales order line.
SecondaryQuantity	Quantity in terms of the secondary unit of measure for a dual unit of measure controlled item.
SecondaryUomCode	Code that identifies the alternative unit of measure that's allowed to quantify a dual unit of measure controlled item.
ServiceLevel	Transportation priority that determines how quickly to transport goods.
ShipToCustContactId	Value that uniquely identifies the contact from the company where the good are shipped.
ShipToCustId	Value that uniquely identifies the customer to whom merchandise is being sent.
ShipToCustLocationId	Value that uniquely identifies the location where the supplier should ship the goods.
SmartFormId	Value that uniquely identifies the smart form from which the item was added to the requisition line.
SourceDocHeaderId	Value that uniquely identifies the suggested source blanket agreement or contract agreement document.
SourceDocLineId	Value that uniquely identifies the suggested source blanket agreement line.
SourceDocumentType	Type of the suggested source document.
SourceOrganizationId	Value that uniquely identifies the inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation.
SourceSubinventory	Subinventory within a source inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation.
SourceTypeCode	Code that identifies the type of supply source for the requisition line. Values include the following values: Internal or External. If Internal, it means the line is sourced from an inventory organization. If External, it means the line is sourced for supplier.
SuggestedBuyerId	Value that uniquely identifies the suggested buyer.
SuggestedSupplierItemNumber	Number of the suggested supplier product.
SuggestedVendorContact	Name of the suggested supplier contact.
SuggestedVendorContactEmail	Email of the suggested supplier contact.
SuggestedVendorContactFax	Fax number of the suggested supplier contact.
SuggestedVendorContactPhone	Phone number of the suggested supplier contact.
SuggestedVendorName	Name of the suggested supplier.
SuggestedVendorSite	Site of the suggested supplier.
SupplierDuns	Data Universal Numbering System code of the suggested supplier.
SupplierRefNumber	Reference Number for the Supplier.
TaxAttrUserOverrideFlag	Indicates whether the tax attributes were overridden by the user.
TaxClassificationCode	Code that identifies the tax classification.
ThirdPtyRegId	Value that uniquely identifies the third party or third party site by a tax authority when it's registered and by which the first party registration will be identified.
ToHeaderId	Value that uniquely identifies the transfer order header.
ToLineId	Value that uniquely identifies the transfer order line.
TrxBusinessCategory	Value that uniquely identifies the Transaction Business Category.
UnNumberId	Value that uniquely identifies the United Nations identification number for hazardous material.
UnitPrice	Price of the requested item in the currency of the buying company.
UnspscCode	Code that identifies the United Nations Standard Products and Services Code for taxonomy of products and services.
UomCode	Code that identifies the unit of measure.
UrgentFlag	Contains one of the following values: true or false. If true, then the requisition line requires urgent processing. If false, then the line doesn't require urgent processing. This attribute doesn't have a default value.
UserDefinedFiscClass	User-defined fiscal classification.
VendorContactId	Value that uniquely identifies the supplier contact.
VendorId	Value that uniquely identifies the supplier.
VendorSiteId	Value that uniquely identifies the supplier site.
WorkOrderId	Value that uniquely identifies the work order in a plant.
WorkOrderNumber	Number of the contract manufacturing work order.
WorkOrderOperationId	Value that uniquely identifies an operation of a work order.
WorkOrderOperationSeq	Value that indicates the execution sequence of the work order operation.
WorkOrderProduct	Value that identifies the finished goods of the contract manufacturing work order.
WorkOrderSubType	Display name that identifies the subtype of the manufacturing work order.