1. REST API for Oracle Fusion Cloud Procurement
  2. Tasks
  3. Purchase Requisitions
  4. Lines

Get all lines

get

/fscmRestApi/resources/11.13.18.05/purchaseRequisitions/{purchaseRequisitionsUniqID}/child/lines

Request

Path Parameters
  • This is the hash key of the attributes which make up the composite key for the Purchase Requisitions resource and used to uniquely identify an instance of Purchase Requisitions. The client should not generate the hash key value. Instead, the client should query on the Purchase Requisitions collection resource in order to navigate to a specific instance of Purchase Requisitions to get the hash key.
Query Parameters
  • This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2

    Format: <attr1>=<val1>,<attr2>=<value2>
  • When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
  • This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.

    Format: ?fields=Attribute1,Attribute2

    Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
  • Used as a predefined finder to search the collection.

    Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>

    The following are the available finder names and corresponding finder variables:

    • PrimaryKey: Finds purchase requisition lines according to the primary key.
      Finder Variables:
      • RequisitionLineId; integer; Value that uniquely identifies a purchasing requisition line.
  • This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
  • This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>

    Example:
    self,canonical
  • Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
  • This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
  • This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY

    Format: ?q=expression1;expression2

    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • AssignedBuyer; string; Name of the person responsible for managing the purchase requisition through its life cycle.
    • CategoryName; string; Name of the purchasing category that is used for classifying the purchase being made by using this order line.
    • CurrencyCode; string; Abbreviation that identifies the purchase requisition currency.
    • EPPLineId; integer; Value that uniquely identifies the external purchase price line.
    • Item; string; Abbreviation that uniquely identifies the item being purchased.
    • ItemDescription; string; Description of the goods or services being purchased.
    • ItemRevision; string; Number that identifies the revision of the item.
    • LastApprovalDate; string; Date when the requisition lines was last approved.
    • LineNumber; number; Number that uniquely identifies the line associated with a purchase requisition.
    • LineStatus; string; Abbreviation that identifies the purchase requisition line status in the line life cycle.
    • LineTypeCode; string; Abbreviation that uniquely identifies the line type. Values include Goods, Fixed Price Services, and so on.
    • NegotiatedByPreparerFlag; boolean; 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.
    • Negotiation; string; Value that identifies the negotiation document associated with the requisition line.
    • NegotiationRequiredFlag; boolean; Contains one of the following values: true or false. If true, then a request for a quotation is required prior to placing the requisition line on a purchase order. If false, then a request for a quotation isn't required. This attribute doesn't have a default value.
    • NewSupplierFlag; boolean; 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.
    • OriginalApprovalDate; string; Date when the requisition line was first approved.
    • POCancelReason; string; Reason provided by the employee for cancelling the purchase order.
    • POHoldReason; string; The reason provided by the buyer while placing the purchase order on hold.
    • Price; number; Price of the requested item in the currency of the supplier.
    • ProcurementBU; string; Business unit responsible for managing the procurement function.
    • PurchaseOrder; string; Number that identifies the purchase order created to fulfill the requisition line.
    • RequestedDeliveryDate; string; Date when the buying company requested the ordered item or service to be delivered.
    • RequestedShipDate; string; Date when the buying company requested the ordered item to be shipped.
    • Requester; string; Person for whom goods or services are being ordered.
    • RequesterId; integer; Value that uniquely identifies the person for whom goods or services are being ordered.
    • RequisitionHeaderId; integer; Value that uniquely identifies the requisition header.
    • RequisitionLineId; integer; Value that uniquely identifies the requisition line.
    • SalesOrder; string; Number that uniquely identifies a backing customer sales order number.
    • ShipToCustomer; string; Name of the party who will receive the materials that are shipped.
    • SourceAgreement; string; Number that uniquely identifies the source agreement referenced by the purchase requisition line.
    • SourceAgreementType; string; Value that indicates whether the referenced agreement is a blanket purchase agreement or a contract purchase agreement.
    • SourceOrganization; string; Name of the inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation.
    • SourceTypeCode; string; Abbreviation that identifies the type of supply source for the requisition line. Values include the following values. Internal: the line is sourced from an inventory organization. External: the line is sourced for supplier.
    • SuggestedSupplier; string; Name of the new supplier suggested on the requisition line for fulfillment of the ordered goods and services.
    • UnitPrice; number; Price of the requested item in the currency of the buying company.
    • UrgentFlag; boolean; 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.
    • WorkOrder; string; Display number that uniquely identifies a work order in a plant.
    • WorkOrderOperationSequence; number; Sequence to use when performing the work order operations.
    • WorkOrderProduct; string; Value that identifies the finished goods of the contract manufacturing work order.
  • The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

There's no request body for this operation.

Back to Top

Response

Supported Media Types

Default Response

The following table describes the default response for this task.
Headers
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Body ()
Root Schema : purchaseRequisitions-lines
Type: object
Show Source
Nested Schema : Items
Type: array
Title: Items
The items in the collection.
Show Source
Nested Schema : purchaseRequisitions-lines-item-response
Type: object
Show Source
  • Title: Meaning
    Read Only: true
    Maximum Length: 80
    Action required of the requisition preparer or a requester on a requisition line.
  • Read Only: true
    Maximum Length: 30
    Abbreviation that identifies the action required of the requisition preparer or a requester on a requisition line.
  • Title: Additional Contact Email
    Maximum Length: 1500
    Email addresses of additional supplier contacts. These email addresses are used to send purchase orders to supplier contacts involved in the procurement process.
  • Read Only: true
    Total amount of the requested items in the currency of the buying company.
  • Title: Assigned Buyer
    Read Only: true
    Maximum Length: 240
    Name of the person responsible for managing the purchase requisition through its life cycle.
  • Title: Name
    Read Only: true
    Maximum Length: 240
    Display name of the person responsible for managing the purchase requisition through its life cycle.
  • Title: Assigned Buyer Email
    Read Only: true
    Maximum Length: 240
    Email address of the person responsible for managing the purchase requisition through its life cycle.
  • Read Only: true
    Value that uniquely identifies the person responsible for managing the purchase requisition through its life cycle.
  • Attachments for Lines
    Title: Attachments for Lines
    The Attachments for Lines resource manages attachments for a purchase requisition line.
  • Read Only: true
    Maximum Length: 1
    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.
  • Read Only: true
    Maximum Length: 1
    Contains one of the following values: true or false. If true, then the blanket purchase agreement description attribute has been updated by the user. If false, then the blanket purchase agreement description attribute hasn't been updated by the user. The default value is false.
  • Read Only: true
    Maximum Length: 1
    Contains one of the following values: true or false. If true, then the blanket purchase agreement price attribute has been updated by the user. If false, then the blanket purchase agreement price attribute hasn't been updated by the user. The default value is false.
  • Title: Name
    Read Only: true
    Maximum Length: 240
    Display name of the person who is responsible for managing the purchase order.
  • Read Only: true
    Maximum Length: 1
    Contains one of the following values: true or false. If true, then the requisition line is being processed by the buyer. If false, then the requisition line isn't being processed by the buyer. The default value is false.
  • Read Only: true
    Date when the requested items were canceled.
  • Read Only: true
    Maximum Length: 240
    Reason for canceling the requested items.
  • Title: Carrier
    Read Only: true
    Maximum Length: 360
    Company that transports goods from one point to another by land, sea, or air.
  • Read Only: true
    Value that uniquely identifies the company that transports goods from one point to another by land, sea, or air.
  • Value that uniquely identifies the purchasing category.
  • Maximum Length: 2400
    Name of the purchasing category that is used for classifying the purchase being made by using this order line.
  • Read Only: true
    Maximum Length: 1
    Default Value: false
    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.
  • Conversion rate to use when converting the currency.
  • Date from when the conversion rate is used to convert an amount into another currency.
  • Maximum Length: 30
    Type of rate used to determine the currency conversion rate for the purchase requisition.
  • Read Only: true
    Maximum Length: 64
    User who created the requisition.
  • Read Only: true
    Date and time when the purchase requisition was initiated.
  • Title: Currency Name
    Maximum Length: 80
    Purchase requisition currency.
  • Total amount of the requested item in the currency of the supplier.
  • Maximum Length: 15
    Abbreviation that identifies the purchase requisition currency.
  • Title: Deliver-to Address
    Read Only: true
    Physical address of the final location where the buying company should deliver the goods previously received from a supplier.
  • Title: Deliver-to Customer
    Read Only: true
    Maximum Length: 360
    Name of the third party to whom the materials need to be delivered.
  • Read Only: true
    Value that uniquely identifies the third party to whom the materials need to be delivered.
  • Value that uniquely identifies the third-party location to which materials need to be delivered.
  • Title: Deliver-to Location
    Maximum Length: 60
    Name of the location to which the buying company should deliver goods received from a supplier.
  • Value that uniquely identifies the final location where the buying company should deliver the goods previously received from a supplier.
  • Title: One-Time Address
    Read Only: true
    Physical address of the one-time location where the buying company should deliver the goods that were previously received from a supplier. This location not internal to the organization.
  • Title: Organization
    Read Only: true
    Maximum Length: 240
    Name of the inventory organization that receives the item.
  • Title: Deliver-to Organization
    Maximum Length: 18
    Abbreviation that identifies the inventory organization where the supplier should deliver the goods.
  • Value that uniquely identifies the inventory organization where the supplier should deliver the goods.
  • Maximum Length: 10
    Name of the subinventory that identifies where to deliver the requested item.
  • Title: Destination Type
    Maximum Length: 80
    Type of destination to determine how the purchased goods or services should be charged. Valid values include Inventory, Expense, Drop Ship, and Work Order.
  • Maximum Length: 25
    Abbreviation that identifies whether the item is for inventory, expense, drop ship, or manufacturing. Valid values include INVENTORY, EXPENSE, DROP SHIP, and MANUFACTURING.
  • Flexfields for Purchase Requisition Lines
    Title: Flexfields for Purchase Requisition Lines
    The Flexfields for Purchase Requisition Lines resource manages details about purchase requisition lines.
  • Maximum Length: 1
    Default Value: false
    Contains one of the following values: Y or N. If Y, then the requisition line isn't automatically sourced. If N, then the requisition is automatically sourced. The default value is N.
  • Distributions
    Title: Distributions
    The Distributions resource manages purchasing details such as details about accounting or the project.
  • Value that uniquely identifies the external purchase price line.
  • Title: Address
    Read Only: true
    Formatted physical address of the final location where the buying company should deliver the goods previously received from a supplier.
  • Title: Funds Status
    Read Only: true
    Maximum Length: 80
    Status of the funds reservation request at the line level.
  • Read Only: true
    Maximum Length: 30
    Abbreviation that identifies the status of funds check or the validation result of funds reservation at the line level.
  • Title: Hazard Class
    Read Only: true
    Maximum Length: 40
    Value that uniquely identifies the hazard class.
  • Title: Code
    Read Only: true
    Maximum Length: 30
    Abbreviation that identifies the hazard class specified on the line.
  • Value that uniquely identifies the hazard class captured on the line to comply with Section 19 of the International Safety Rating System.
  • Information Templates for Purchase Requisition Lines
    Title: Information Templates for Purchase Requisition Lines
    The Information Templates for Purchase Requisitions Lines resource manages the information templates associated with a smart form used to create a requisition line. This resource is not currently used.
  • Maximum Length: 1
    Contains one of the following values: Y or N. If Y, then the requisition line information templates were reviewed by the user. If N, then the requisition line information templates weren't reviewed by the user.
  • Maximum Length: 300
    Abbreviation that uniquely identifies the item being purchased.
  • Maximum Length: 240
    Description of the goods or services being purchased.
  • Value that uniquely identifies the item being purchased.
  • Maximum Length: 18
    Number that identifies the revision of the item.
  • Maximum Length: 1
    This attribute isn't currently used.
  • Read Only: true
    Date when the requisition lines was last approved.
  • Read Only: true
    Date when the requisition line was last submitted for approval.
  • Read Only: true
    Date when the record was last updated.
  • Read Only: true
    Maximum Length: 64
    User who most recently updated the record.
  • Read Only: true
    Maximum Length: 100
    Code that indicates additional information about a line lifecycle. This information is used to indicate the secondary status of a requisition line.
  • Title: Lifecycle Status
    Read Only: true
    Maximum Length: 80
    Status indicating the post approval progress of the requisition line.
  • Read Only: true
    Maximum Length: 30
    Abbreviation that identifies the requisition line lifecycle status.
  • Title: Image URL
    Read Only: true
    URL (Uniform Resource Locator) that locates the image representing the requisition line item, if any.
  • Number that uniquely identifies the line associated with a purchase requisition.
  • Read Only: true
    Maximum Length: 25
    Abbreviation that identifies the purchase requisition line status in the line life cycle.
  • Title: Status
    Read Only: true
    Maximum Length: 80
    Status of the requisition line.
  • Title: Line Type Code
    Maximum Length: 30
    Abbreviation that uniquely identifies the line type. Values include Goods, Fixed Price Services, and so on.
  • Value that uniquely identifies type that indicates whether a purchase requisition line is for goods or services.
  • Read Only: true
    Maximum Length: 25
    Abbreviation that identifies the type of agreement line. Valid values are QUANTITY or FIXED PRICE.
  • Links
  • Maximum Length: 240
    Name of the company that manufactures the item being purchased.
  • Maximum Length: 700
    Number that uniquely identifies the item as provided by the manufacturer.
  • Maximum Length: 30
    Value that uniquely identifies the Oracle Healthcare Marketplace Item.
  • Title: Mode of Transport
    Read Only: true
    Maximum Length: 80
    Mode of transportation used to ship the product, such as truck, air, or boat.
  • Read Only: true
    Maximum Length: 30
    Abbreviation that identifies the mode of transport.
  • Title: Modified by Buyer
    Read Only: true
    Maximum Length: 240
    Buyer who modified the requisition line by splitting the requisition line or by replacing the requested item with a catalog item.
  • Read Only: true
    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.
  • Maximum Length: 1
    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.
  • Read Only: true
    Maximum Length: 40
    Value that identifies the negotiation document associated with the requisition line.
  • Read Only: true
    Value that uniquely identifies the negotiation document associated with the requisition line.
  • Read Only: true
    Number that identifies the negotiation line associated with the requisition line.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then a request for a quotation is required prior to placing the requisition line on a purchase order. If false, then a request for a quotation isn't required. This attribute doesn't have a default value.
  • Maximum Length: 1
    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.
  • Title: Note to Buyer
    Maximum Length: 1000
    Note to the buyer on the purchase requisition.
  • Title: Note to Receiver
    Maximum Length: 1000
    Note to the receiver on the purchase requisition.
  • Title: Note to Supplier
    Maximum Length: 1000
    Note to the supplier on the purchase requisition.
  • Read Only: true
    Maximum Length: 1
    Default Value: false
    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 Fusion Cloud Global Human Resources. The default value is false.
  • Read Only: true
    Maximum Length: 1
    Contains one of the following values: true or false. If true, then the requisition line is part of an active sourcing negotiation in Oracle Sourcing. If false, then the requisition line isn't part of an active negotiation. This attribute doesn't have a default value.
  • Read Only: true
    Date when the requisition line was first approved.
  • Read Only: true
    Date when the requisition line was first submitted for approval.
  • Read Only: true
    Maximum Length: 240
    Functional reason for the failure of automatic processing of requisition line to purchase order.
  • Read Only: true
    Maximum Length: 30
    Abbreviation that indicates the reason for the failure of automatic processing of requisition line to purchase order.
  • Read Only: true
    Value that uniquely identifies the buyer who is responsible for managing the purchase order.
  • Title: Cancellation Reason
    Read Only: true
    Maximum Length: 240
    Reason provided by the employee for cancelling the purchase order.
  • Read Only: true
    Value that uniquely identifies the purchase order.
  • Read Only: true
    The reason provided by the buyer while placing the purchase order on hold.
  • Read Only: true
    Value that uniquely identifies the parent purchase order line.
  • Price of the requested item in the currency of the supplier.
  • Title: Procurement BU
    Read Only: true
    Maximum Length: 240
    Business unit responsible for managing the procurement function.
  • Read Only: true
    Value that uniquely identifies the business unit responsible for managing the procurement function.
  • Value that uniquely identifies the public shopping list.
  • Title: Order
    Read Only: true
    Maximum Length: 30
    Number that identifies the purchase order created to fulfill the requisition line.
  • Quantity of the goods being purchased.
  • Date when the buying company requested the ordered item or service to be delivered.
  • Read Only: true
    Date when the buying company requested the ordered item to be shipped.
  • Title: Requester
    Read Only: true
    Maximum Length: 240
    Person for whom goods or services are being ordered.
  • Title: Name
    Read Only: true
    Maximum Length: 240
    Display name of the person for whom goods or services are being ordered.
  • Title: Requester Email
    Maximum Length: 240
    Email address of the person for whom goods or services are being ordered.
  • Value that uniquely identifies the person for whom goods or services are being ordered.
  • Read Only: true
    Value that uniquely identifies the requisition header.
  • Read Only: true
    Maximum Length: 30
    Value that indicates the group of the requisition line.
  • Read Only: true
    Value that uniquely identifies the requisition line.
  • Read Only: true
    Maximum Length: 1
    Value that indicates if a requisition line is available for processing by the buyer. Valid values include Y, N, and P, where P indicates already processed.
  • Read Only: true
    Uniquely identifies the request ID of the Generate Orders process that processed the requisition line.
  • Maximum Length: 25
    Default Value: REST_INTEGRATION
    Value that indicates the source of the line. This attribute isn't currently used.
  • Read Only: true
    Number that identifies the line in a response submitted by supplier for a negotiation.
  • Read Only: true
    Number that identifies the response submitted by supplier for a negotiation document.
  • Title: Returned by Buyer
    Read Only: true
    Maximum Length: 240
    Name of the buyer who returned the requisition line.
  • Read Only: true
    Value that uniquely identifies the buyer who returned the requisition line.
  • Read Only: true
    Maximum Length: 4000
    Reason provided by the buyer while returning the requisition line.
  • Read Only: true
    Maximum Length: 50
    Number that uniquely identifies a backing customer sales order number.
  • Read Only: true
    Maximum Length: 50
    Number that uniquely identifies the sales order line for a given customer sales order.
  • Read Only: true
    Maximum Length: 50
    Number that uniquely identifies the sales order schedule for a given customer sales order line.
  • Scheduled quantity in terms of the secondary unit of measure for a dual unit of measure controlled item.
  • Title: UOM Name
    Read Only: true
    Maximum Length: 25
    Secondary unit of measure to use for the quantity of a dual unit of measure controlled item.
  • Read Only: true
    Maximum Length: 3
    Abbreviation that identifies the alternative unit of measure that is allowed to quantify a dual unit of measure controlled item.
  • Title: Service Level
    Read Only: true
    Maximum Length: 80
    Transportation priority that determines how quickly to transport goods.
  • Read Only: true
    Maximum Length: 30
    Abbreviation that identifies the service level for the shipping method.
  • Title: Ship-to Customer
    Read Only: true
    Maximum Length: 360
    Name of the party who will receive the materials that are shipped.
  • Read Only: true
    Value that uniquely identifies the third party to which materials need to be shipped.
  • Value that uniquely identifies the smart form. This attribute isn't currently used.
  • Maximum Length: 250
    Name of the smart form on the requisition line. This attribute isn't currently used.
  • Title: Agreement
    Maximum Length: 30
    Number that uniquely identifies the source agreement referenced by the purchase requisition line.
  • Value that uniquely identifies the source agreement referenced by the purchase requisition line.
  • Value that uniquely identifies the source agreement line for a given source agreement.
  • Title: Agreement Line
    Number that identifies the line of the source agreement referenced by the purchase requisition line.
  • Title: Agreement Type
    Read Only: true
    Maximum Length: 80
    Value that indicates whether the referenced agreement is a blanket purchase agreement or a contract purchase agreement.
  • Maximum Length: 25
    Abbreviation that identifies the source agreement type. Values include CONTRACT and BLANKET.
  • Title: Source Organization
    Read Only: true
    Maximum Length: 240
    Name of the inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation.
  • Maximum Length: 18
    Abbreviation that identifies the inventory organization that supplies the item to the destination inventory organization in an internal material transfer operation.
  • Value that uniquely identifies the inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation.
  • Maximum Length: 10
    Subinventory within a source inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation.
  • Title: Source Type
    Maximum Length: 80
    Value that indicates the type of source the requisition line is sourced from. For example: Inventory, Supplier.
  • Maximum Length: 10
    Default Value: EXTERNAL
    Abbreviation that identifies the type of supply source for the requisition line. Values include the following values. Internal: the line is sourced from an inventory organization. External: the line is sourced for supplier.
  • Special Handling Flexfields for Purchase Requisition Lines
    Title: Special Handling Flexfields for Purchase Requisition Lines
    The Special Handling Flexfields for Purchase Requisitions Lines resource manages details about purchase requisition lines.
  • Title: Suggested Buyer
    Read Only: true
    Maximum Length: 240
    Name of the buyer suggested for managing the purchase requisition line through its life cycle.
  • Title: Suggested Buyer Email
    Maximum Length: 240
    Email address of the suggested buyer.
  • Value that uniquely identifies the suggested buyer.
  • Maximum Length: 360
    Name of the new supplier suggested on the requisition line for fulfillment of the ordered goods and services.
  • Maximum Length: 80
    Name of the person representing the new supplier involved in supporting the customer relationship.
  • Maximum Length: 1000
    Email address of the person representing the new supplier.
  • Maximum Length: 30
    Fax number of the person representing the new supplier.
  • Maximum Length: 30
    Phone number of the person representing the new supplier.
  • Maximum Length: 240
    Value that uniquely identifies the new supplier.
  • Maximum Length: 360
    Name of the supplier tasked with fulfillment of the ordered goods and services.
  • Maximum Length: 4000
    Name of the person representing the supplier with regards to communication with the buying company.
  • Read Only: true
    Maximum Length: 2000
    Email address of the supplier contact.
  • Read Only: true
    Maximum Length: 255
    Fax number if the supplier contact.
  • Value that uniquely identifies the supplier contact.
  • Read Only: true
    Maximum Length: 255
    Phone number of the supplier contact.
  • Value that uniquely identifies the supplier.
  • Maximum Length: 150
    Auxiliary part number that uniquely identifies the supplier item.
  • Title: Supplier Item
    Maximum Length: 300
    Number that identifies the supplier or code for the goods or services ordered on the purchase requisition line.
  • Read Only: true
    Maximum Length: 360
    Name of the supplier who fulfills the ordered item.
  • Title: Supplier Site
    Maximum Length: 240
    Name of the supplier location from where goods or services are purchased.
  • Value that uniquely identifies the supplier site.
  • Title: Transfer Order
    Read Only: true
    Maximum Length: 50
    Number that identifies the transfer order document associated with the requisition line.
  • Read Only: true
    Value that uniquely identifies the transfer order document associated with the requisition line.
  • Read Only: true
    Value that uniquely identifies the transfer order line associated with the requisition line.
  • Price of the requested item in the currency of the buying company.
  • Title: UN Number
    Read Only: true
    Maximum Length: 20
    United Nations identification number for the hazardous material.
  • Value that uniquely identifies the United Nations identification number for hazardous material.
  • Maximum Length: 700
    Abbreviation that identifies the United Nations Standard Products and Services Code (UNSPSC) for taxonomy of products and services.
  • Title: UOM Name
    Maximum Length: 25
    Unit of measure of the item quantity.
  • Maximum Length: 3
    Abbreviation that identifies the unit of measure.
  • Maximum Length: 1
    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.
  • Read Only: true
    Maximum Length: 120
    Display number that uniquely identifies a work order in a plant.
  • Read Only: true
    Value that uniquely identifies the work order in a plant.
  • Read Only: true
    Value that uniquely identifies an operation of a work order.
  • Read Only: true
    Sequence to use when performing the work order operations.
  • Read Only: true
    Maximum Length: 300
    Value that identifies the finished goods of the contract manufacturing work order.
  • Read Only: true
    Maximum Length: 30
    Display name used to identify the subtype of the manufacturing work order.
Nested Schema : Attachments for Lines
Type: array
Title: Attachments for Lines
The Attachments for Lines resource manages attachments for a purchase requisition line.
Show Source
Nested Schema : Flexfields for Purchase Requisition Lines
Type: array
Title: Flexfields for Purchase Requisition Lines
The Flexfields for Purchase Requisition Lines resource manages details about purchase requisition lines.
Show Source
Nested Schema : Distributions
Type: array
Title: Distributions
The Distributions resource manages purchasing details such as details about accounting or the project.
Show Source
Nested Schema : Information Templates for Purchase Requisition Lines
Type: array
Title: Information Templates for Purchase Requisition Lines
The Information Templates for Purchase Requisitions Lines resource manages the information templates associated with a smart form used to create a requisition line. This resource is not currently used.
Show Source
Nested Schema : Special Handling Flexfields for Purchase Requisition Lines
Type: array
Title: Special Handling Flexfields for Purchase Requisition Lines
The Special Handling Flexfields for Purchase Requisitions Lines resource manages details about purchase requisition lines.
Show Source
  • Discriminator: __FLEX_Context
    Discriminator: { "propertyName":"__FLEX_Context", "mapping":{ "ORA_PO_BILL_ONLY_LINES":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_specialHandlingLines_view_RequisitionLineSHDFFORA__5FPO__5FBILL__5FONLY__5FLINESVO-item-response" } }
Nested Schema : purchaseRequisitions-lines-attachments-item-response
Type: object
Show Source
Nested Schema : purchaseRequisitions-lines-DFF-item-response
Type: object
Show Source
Nested Schema : purchaseRequisitions-lines-distributions-item-response
Type: object
Show Source
Nested Schema : Flexfields for Purchase Requisition Distributions
Type: array
Title: Flexfields for Purchase Requisition Distributions
The Flexfields for Purchase Requisition Distributions resource manages details about purchase requisition distributions.
Show Source
Nested Schema : Project Costing Flexfields for Purchase Requisition Distributions
Type: array
Title: Project Costing Flexfields for Purchase Requisition Distributions
The Project Costing Flexfields for Purchase Requisition Distributions resource manages details about purchase requisition distributions.
Show Source
  • Discriminator: __FLEX_Context
    Discriminator: { "propertyName":"__FLEX_Context", "mapping":{ "AP_Distribution_Sets":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FDistribution__5FSetsVO-item-response", "AP_Invoice_Distribution":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FInvoice__5FDistributionVO-item-response", "AP_Invoice_Line":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FInvoice__5FLineVO-item-response", "EXM_Expense_Report":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFEXM__5FExpense__5FReportVO-item-response", "EXM_Expense_Report_Line":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFEXM__5FExpense__5FReport__5FLineVO-item-response", "INV_Misc_Transactions":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFINV__5FMisc__5FTransactionsVO-item-response", "OM_Sales_Order":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFOM__5FSales__5FOrderVO-item-response", "PJC_All":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPJC__5FAllVO-item-response", "PJC_Expenditure_Batch":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPJC__5FExpenditure__5FBatchVO-item-response", "POR_Requisition":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPOR__5FRequisitionVO-item-response", "POR_User_Preferences":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPOR__5FUser__5FPreferencesVO-item-response", "PO_Purchase_Order":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrderVO-item-response", "PO_Purchase_Order_Line":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrder__5FLineVO-item-response", "PO_Purchase_Order_Schedule":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrder__5FScheduleVO-item-response" } }
Nested Schema : purchaseRequisitions-lines-distributions-DFF-item-response
Type: object
Show Source
Nested Schema : Discriminator: __FLEX_Context
Type: object
Discriminator: __FLEX_Context

Discriminator Values

Match One Schema
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FDistribution__5FSetsVO-item-response
Type: object
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FInvoice__5FDistributionVO-item-response
Type: object
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FInvoice__5FLineVO-item-response
Type: object
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFEXM__5FExpense__5FReportVO-item-response
Type: object
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFEXM__5FExpense__5FReport__5FLineVO-item-response
Type: object
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFINV__5FMisc__5FTransactionsVO-item-response
Type: object
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFOM__5FSales__5FOrderVO-item-response
Type: object
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPJC__5FAllVO-item-response
Type: object
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPJC__5FExpenditure__5FBatchVO-item-response
Type: object
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPOR__5FRequisitionVO-item-response
Type: object
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPOR__5FUser__5FPreferencesVO-item-response
Type: object
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrderVO-item-response
Type: object
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrder__5FLineVO-item-response
Type: object
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrder__5FScheduleVO-item-response
Type: object
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Nested Schema : purchaseRequisitions-lines-informationTemplates-item-response
Type: object
Show Source
Nested Schema : Information Template Flexfields for Purchase Requisition Lines
Type: array
Title: Information Template Flexfields for Purchase Requisition Lines
The Information Template Flexfields for Purchase Requisitions Lines resource manages details about information templates descriptive flexfields.
Show Source
Nested Schema : purchaseRequisitions-lines-informationTemplates-informationTemplateDFF-item-response
Type: object
Show Source
Nested Schema : Discriminator: __FLEX_Context
Type: object
Discriminator: __FLEX_Context

Discriminator Values

Match One Schema
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_specialHandlingLines_view_RequisitionLineSHDFFORA__5FPO__5FBILL__5FONLY__5FLINESVO-item-response
Type: object
Show Source
Nested Schema : Links
Type: array
Title: Links
The link relations associated with the resource instance.
Show Source
Back to Top

Examples

This example describes how to get all lines.

Example cURL Command

Use the following cURL command to submit a request on the REST resource:

curl -u username:password "https://servername/fscmRestApi/resources/version/purchaseRequisitions/purchaseRequisitionsUniqID/child/lines"

Example Response Body

The following shows an example of the response body in JSON format.

{
	"items": [
	{
		"RequisitionHeaderId": 300100152073010,
		"RequisitionLineId": 300100152073011,
		"LineNumber": 1,
		"LineTypeId": 1,
		"LineTypeCode": "Goods",
		"RequisitionLineSource": "CATALOG",
		"CategoryId": 2915,
		"CategoryName": "Laptop Accessory",
		"ItemDescription": "Netbook Carrycase Black",
		"ItemId": null,
		"Item": null,
		"ItemRevision": null,
		"Quantity": 1,
		"SecondaryQuantity": null,
		"UnitPrice": 22,
		"CurrencyCode": "USD",
		"Currency": "US Dollar",
		"UOMCode": "Ea",
		"UOM": "Each",
		"SecondaryUOMCode": null,
		"SecondaryUOM": null,
		"ConversionRateType": null,
		"ConversionRateDate": null,
		"ConversionRate": null,
		"Price": 22,
		"LineStatus": "APPROVED",
		"Amount": null,
		"CurrencyAmount": null,
		"UrgentFlag": false,
		"NegotiatedByPreparerFlag": true,
		"NegotiationRequiredFlag": null,
		"SourceAgreementTypeCode": "BLANKET",
		"SourceAgreementType": "Blanket Purchase Agreement",
		"SourceAgreementHeaderId": 300100104065999,
		"SourceAgreement": "1002429",
		"SourceAgreementLineId": 403962,
		"SourceAgreementLineNumber": 30,
		"UNNumberId": null,
		"UNNumber": null,
		"HazardClassId": null,
		"HazardClass": null,
		"HazardClassCode": null,
		"UNSPSCCode": null,
		"ManufacturerName": "Computeco",
		"ManufacturerPartNumber": null,
		"BPAPriceUserOverrideFlag": null,
		"NewSupplierFlag": false,
		"SupplierId": 559,
		"Supplier": "CV_SuppA02",
		"SupplierSiteId": 5058,
		"SupplierSite": "CVSuppA02Site01",
		"SupplierContactId": null,
		"SupplierContact": null,
		"SupplierContactEmail": null,
		"SupplierContactPhone": null,
		"SupplierContactFax": null,
		"SuggestedSupplier": null,
		"SuggestedSupplierSite": null,
		"SuggestedSupplierContact": null,
		"SuggestedSupplierContactPhone": null,
		"SuggestedSupplierContactFax": null,
		"SuggestedSupplierContactEmail": null,
		"SupplierItemNumber": null,
		"RequesterId": 100010026864135,
		"Requester": "Antilla,Penelope",
		"RequesterEmail": "sendmail-test-discard@example.com",
		"SuggestedBuyerId": null,
		"SuggestedBuyer": null,
		"SuggestedBuyerEmail": null,
		"ModifiedByBuyerId": null,
		"ModifiedByBuyer": null,
		"AssignedBuyerId": 100010026863783,
		"AssignedBuyer": "Furey,Clare",
		"AssignedBuyerEmail": "CVBUYER01@example.com",
		"RequestedDeliveryDate": "2018-06-25",
		"DestinationTypeCode": "EXPENSE",
		"DestinationType": "Expense",
		"DestinationOrganizationId": 204,
		"DestinationOrganizationCode": "V1",
		"DestinationOrganization": "Vision Operations",
		"DestinationSubinventory": null,
		"OneTimeLocationFlag": false,
		"DeliverToLocationId": "204",
		"DeliverToLocationCode": "V1- New York City",
		"DeliverToAddress": "90 Fifth Avenue, New York, NY 10022-3422, New York, United States",
		"NoteToBuyer": null,
		"NoteToReceiver": null,
		"NoteToSupplier": null,
		"POAutomationFailedReasonCode": null,
		"POAutomationFailedReason": null,
		"POHeaderId": 300100152080806,
		"POLineId": 300100152080807,
		"PurchaseOrder": "1004418",
		"ProcurementBUId": 204,
		"ProcurementBU": "Vision Operations",
		"SourceTypeCode": "EXTERNAL",
		"SourceType": "Supplier",
		"SourceOrganizationId": null,
		"SourceOrganizationCode": null,
		"SourceOrganization": null,
		"SourceSubinventory": null,
		"TransferOrderHeaderId": null,
		"TransferOrder": null,
		"TransferOrderLineId": null,
		"NegotiationHeaderId": null,
		"Negotiation": null,
		"NegotiationLineNumber": null,
		"ResponseNumber": null,
		"ResponseLineNumber": null,
		"OnNegotiationFlag": null,
		"WorkOrderId": null,
		"WorkOrder": null,
		"WorkOrderOperationId": null,
		"WorkOrderOperationSequence": null,
		"WorkOrderProduct": null,
		"WorkOrderSubType": null,
		"BackToBackFlag": null,
		"ConfiguredItemFlag": false,
		"DeliverToCustomerId": null,
		"DeliverToCustomer": null,
		"DeliverToCustomerLocationId": null,
		"RequestedShipDate": null,
		"SalesOrderLineNumber": null,
		"SalesOrder": null,
		"SalesOrderScheduleNumber": null,
		"ShipToCustomerId": null,
		"ShipToCustomer": null,
		"ServiceLevelCode": null,
		"ServiceLevel": null,
		"ModeOfTransportCode": null,
		"ModeOfTransport": null,
		"CarrierId": null,
		"Carrier": null,
		"CreatedBy": "CVRQST03",
		"CreationDate": "2018-06-18T21:42:24.232+00:00",
		"LastUpdatedBy": "CVRQST03",
		"LastUpdateDate": "2018-06-19T07:39:58.811+00:00",
		"LastSubmittedDate": "2018-06-19T07:39:30.757+00:00",
		"LastApprovalDate": "2018-06-19T07:39:58.785+00:00",
		"OriginalSubmittedDate": null,
		"OriginalApprovalDate": null,
		"CancelDate": null,
		"CancelReason": null,
		"links": [
		{
			"rel": "self",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100152073010/child/lines/300100152073011",
			"name": "lines",
			"kind": "item"
		},
		{
			"rel": "canonical",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100152073010/child/lines/300100152073011",
			"name": "lines",
			"kind": "item"
		},
		{
			"rel": "parent",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100152073010",
			"name": "purchaseRequisitions",
			"kind": "item"
		}
		]
	},
	{
		"RequisitionHeaderId": 300100152073010,
		"RequisitionLineId": 300100152112336,
		"LineNumber": 2,
		"LineTypeId": 1,
		"LineTypeCode": "Goods",
		"RequisitionLineSource": "QUICK_ENTRY",
		"CategoryId": 3124,
		"CategoryName": "zPOR-PRC_QA-BI-Cat01",
		"ItemDescription": "Liquid Soap for Restrooms",
		"ItemId": 11462,
		"Item": "Liquid Soap",
		"ItemRevision": "A",
		"Quantity": 1,
		"SecondaryQuantity": null,
		"UnitPrice": 12,
		"CurrencyCode": "USD",
		"Currency": "US Dollar",
		"UOMCode": "GAL",
		"UOM": "Gallon",
		"SecondaryUOMCode": null,
		"SecondaryUOM": null,
		"ConversionRateType": null,
		"ConversionRateDate": null,
		"ConversionRate": null,
		"Price": 12,
		"LineStatus": "APPROVED",
		"Amount": null,
		"CurrencyAmount": null,
		"UrgentFlag": false,
		"NegotiatedByPreparerFlag": null,
		"NegotiationRequiredFlag": null,
		"SourceAgreementTypeCode": "CONTRACT",
		"SourceAgreementType": "Contract Purchase Agreement",
		"SourceAgreementHeaderId": 424959,
		"SourceAgreement": "1002094",
		"SourceAgreementLineId": null,
		"SourceAgreementLineNumber": null,
		"UNNumberId": null,
		"UNNumber": null,
		"HazardClassId": null,
		"HazardClass": null,
		"HazardClassCode": null,
		"UNSPSCCode": null,
		"ManufacturerName": null,
		"ManufacturerPartNumber": null,
		"BPAPriceUserOverrideFlag": null,
		"NewSupplierFlag": null,
		"SupplierId": 12,
		"Supplier": "CV_SuppA01",
		"SupplierSiteId": 2444,
		"SupplierSite": "CVSuppA01Site01",
		"SupplierContactId": null,
		"SupplierContact": null,
		"SupplierContactEmail": null,
		"SupplierContactPhone": null,
		"SupplierContactFax": null,
		"SuggestedSupplier": null,
		"SuggestedSupplierSite": null,
		"SuggestedSupplierContact": null,
		"SuggestedSupplierContactPhone": null,
		"SuggestedSupplierContactFax": null,
		"SuggestedSupplierContactEmail": null,
		"SupplierItemNumber": null,
		"RequesterId": 100010026864135,
		"Requester": "Jones,Penelope",
		"RequesterEmail": "sendmail-test-discard@example.com",
		"SuggestedBuyerId": null,
		"SuggestedBuyer": null,
		"SuggestedBuyerEmail": null,
		"ModifiedByBuyerId": null,
		"ModifiedByBuyer": null,
		"AssignedBuyerId": 100010026863783,
		"AssignedBuyer": "Furey,Clare",
		"AssignedBuyerEmail": "CVBUYER01@test.com",
		"RequestedDeliveryDate": "2018-06-26",
		"DestinationTypeCode": "INVENTORY",
		"DestinationType": "Inventory",
		"DestinationOrganizationId": 204,
		"DestinationOrganizationCode": "V1",
		"DestinationOrganization": "Vision Operations",
		"DestinationSubinventory": "EB",
		"OneTimeLocationFlag": false,
		"DeliverToLocationId": "204",
		"DeliverToLocationCode": "V1- New York City",
		"DeliverToAddress": "90 Avenue, New York, NY 122-3422, New York, United States",
		"NoteToBuyer": null,
		"NoteToReceiver": null,
		"NoteToSupplier": null,
		"POAutomationFailedReasonCode": "PO_RTP_NOT_NEG_BY_PREP",
		"POAutomationFailedReason": "The requisition line failed automation because the price is not negotiated.",
		"POHeaderId": null,
		"POLineId": null,
		"PurchaseOrder": null,
		"ProcurementBUId": 204,
		"ProcurementBU": "Vision Operations",
		"SourceTypeCode": "EXTERNAL",
		"SourceType": "Supplier",
		"SourceOrganizationId": null,
		"SourceOrganizationCode": null,
		"SourceOrganization": null,
		"SourceSubinventory": null,
		"TransferOrderHeaderId": null,
		"TransferOrder": null,
		"TransferOrderLineId": null,
		"NegotiationHeaderId": null,
		"Negotiation": null,
		"NegotiationLineNumber": null,
		"ResponseNumber": null,
		"ResponseLineNumber": null,
		"OnNegotiationFlag": null,
		"WorkOrderId": null,
		"WorkOrder": null,
		"WorkOrderOperationId": null,
		"WorkOrderOperationSequence": null,
		"WorkOrderProduct": null,
		"WorkOrderSubType": null,
		"BackToBackFlag": null,
		"ConfiguredItemFlag": false,
		"DeliverToCustomerId": null,
		"DeliverToCustomer": null,
		"DeliverToCustomerLocationId": null,
		"RequestedShipDate": null,
		"SalesOrderLineNumber": null,
		"SalesOrder": null,
		"SalesOrderScheduleNumber": null,
		"ShipToCustomerId": null,
		"ShipToCustomer": null,
		"ServiceLevelCode": null,
		"ServiceLevel": null,
		"ModeOfTransportCode": null,
		"ModeOfTransport": null,
		"CarrierId": null,
		"Carrier": null,
		"CreatedBy": "CVRQST03",
		"CreationDate": "2018-06-19T07:37:09.141+00:00",
		"LastUpdatedBy": "CVRQST03",
		"LastUpdateDate": "2018-06-19T07:39:58.818+00:00",
		"LastSubmittedDate": "2018-06-19T07:39:30.757+00:00",
		"LastApprovalDate": "2018-06-19T07:39:58.785+00:00",
		"OriginalSubmittedDate": null,
		"OriginalApprovalDate": null,
		"CancelDate": null,
		"CancelReason": null,
		"links": [
		{
			"rel": "self",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100152073010/child/lines/300100152112336",
			"name": "lines",
			"kind": "item"
		},
		{
			"rel": "canonical",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100152073010/child/lines/300100152112336",
			"name": "lines",
			"kind": "item"
		},
		{
			"rel": "parent",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100152073010",
			"name": "purchaseRequisitions",
			"kind": "item"
		}
		]
	}
	],
	"count": 2,
	"hasMore": false,
	"limit": 25,
	"offset": 0,
	"links": [
	{
		"rel": "self",
		"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100152073010/child/lines",
		"name": "lines",
		"kind": "collection"
	}
	]
}

Example 2 cURL Command

Use the following cURL command to submit a request on the REST resource to get all lines according to according a query criteria:

curl -u username:password "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553/child/lines?q=PurchaseOrder is not null"

Example 2 Response Body

The following shows an example of the response body in JSON format.

{
	"items": [
	{
		"RequisitionHeaderId": 82553,
		"RequisitionLineId": 80262,
		"LineNumber": 1,
		"LineTypeId": 1,
		"LineTypeCode": "Goods",
		"RequisitionLineSource": "REQ_SERVICE",
		"CategoryId": 1,
		"CategoryName": "Miscellaneous_1",
		"ItemDescription": "RAM - 512MB",
		"ItemId": 4725,
		"Item": "CM08512",
		"ItemRevision": null,
		"Quantity": 50,
		"SecondaryQuantity": null,
		"UnitPrice": 100,
		"CurrencyCode": "USD",
		"Currency": "US Dollar",
		"UOMCode": "Ea",
		"UOM": "Each",
		"SecondaryUOMCode": null,
		"SecondaryUOM": null,
		"ConversionRateType": null,
		"ConversionRateDate": null,
		"ConversionRate": null,
		"Price": 100,
		"LineStatus": "APPROVED",
		"Amount": null,
		"CurrencyAmount": null,
		"UrgentFlag": null,
		"NegotiatedByPreparerFlag": null,
		"NegotiationRequiredFlag": null,
		"SourceAgreementTypeCode": null,
		"SourceAgreementType": null,
		"SourceAgreementHeaderId": null,
		"SourceAgreement": null,
		"SourceAgreementLineId": null,
		"SourceAgreementLineNumber": null,
		"UNNumberId": null,
		"UNNumber": null,
		"HazardClassId": null,
		"HazardClass": null,
		"HazardClassCode": null,
		"UNSPSCCode": null,
		"ManufacturerName": null,
		"ManufacturerPartNumber": null,
		"BPAPriceUserOverrideFlag": false,
		"NewSupplierFlag": null,
		"SupplierId": null,
		"Supplier": null,
		"SupplierSiteId": null,
		"SupplierSite": null,
		"SupplierContactId": null,
		"SupplierContact": null,
		"SupplierContactEmail": null,
		"SupplierContactPhone": null,
		"SupplierContactFax": null,
		"SuggestedSupplier": null,
		"SuggestedSupplierSite": null,
		"SuggestedSupplierContact": null,
		"SuggestedSupplierContactPhone": null,
		"SuggestedSupplierContactFax": null,
		"SuggestedSupplierContactEmail": null,
		"SupplierItemNumber": null,
		"RequesterId": 100010026864111,
		"Requester": "Smith,Kurt",
		"RequesterEmail": "sendmail-test-discard@example.com",
		"SuggestedBuyerId": null,
		"SuggestedBuyer": null,
		"SuggestedBuyerEmail": null,
		"ModifiedByBuyerId": null,
		"ModifiedByBuyer": null,
		"AssignedBuyerId": 100010026863783,
		"AssignedBuyer": "Jones,Clare",
		"AssignedBuyerEmail": "CVBUYER01@example.com",
		"RequestedDeliveryDate": "2021-06-19",
		"DestinationTypeCode": "DROP SHIP",
		"DestinationType": "Drop Ship",
		"DestinationOrganizationId": 204,
		"DestinationOrganizationCode": "V1",
		"DestinationOrganization": "Vision Operations",
		"DestinationSubinventory": null,
		"OneTimeLocationFlag": false,
		"DeliverToLocationId": null,
		"DeliverToLocationCode": "Vision & Co.",
		"DeliverToAddress": null,
		"NoteToBuyer": null,
		"NoteToReceiver": null,
		"NoteToSupplier": null,
		"POAutomationFailedReasonCode": "PO_RTP_SUPP_NOT_KNOWN",
		"POAutomationFailedReason": "The requisition line failed automation because a supplier and site could not be determined.",
		"POHeaderId": 300100152112015,
		"POLineId": 300100152112016,
		"PurchaseOrder": "1004416",
		"ProcurementBUId": 204,
		"ProcurementBU": "Vision Operations",
		"SourceTypeCode": "EXTERNAL",
		"SourceType": "Supplier",
		"SourceOrganizationId": null,
		"SourceOrganizationCode": null,
		"SourceOrganization": null,
		"SourceSubinventory": null,
		"TransferOrderHeaderId": null,
		"TransferOrder": null,
		"TransferOrderLineId": null,
		"NegotiationHeaderId": null,
		"Negotiation": null,
		"NegotiationLineNumber": null,
		"ResponseNumber": null,
		"ResponseLineNumber": null,
		"OnNegotiationFlag": null,
		"WorkOrderId": null,
		"WorkOrder": null,
		"WorkOrderOperationId": null,
		"WorkOrderOperationSequence": null,
		"WorkOrderProduct": null,
		"WorkOrderSubType": null,
		"BackToBackFlag": false,
		"ConfiguredItemFlag": false,
		"DeliverToCustomerId": 1257,
		"DeliverToCustomer": "Vision & Co.",
		"DeliverToCustomerLocationId": 961,
		"RequestedShipDate": "2051-05-18",
		"SalesOrderLineNumber": "1",
		"SalesOrder": "PORDSB10001 Test",
		"SalesOrderScheduleNumber": "1",
		"ShipToCustomerId": 1257,
		"ShipToCustomer": "Vision & Co.",
		"ServiceLevelCode": "2DA",
		"ServiceLevel": "2nd day air",
		"ModeOfTransportCode": "PARCEL",
		"ModeOfTransport": "Parcel",
		"CarrierId": 12519,
		"Carrier": "Airborne",
		"CreatedBy": "CVBUYER01",
		"CreationDate": "2018-06-19T07:04:25+00:00",
		"LastUpdatedBy": "CVBUYER01",
		"LastUpdateDate": "2018-06-19T07:04:42.158+00:00",
		"LastSubmittedDate": null,
		"LastApprovalDate": "2018-06-19T07:04:42.131+00:00",
		"OriginalSubmittedDate": null,
		"OriginalApprovalDate": null,
		"CancelDate": null,
		"CancelReason": null,
		"links": [
		{
			"rel": "self",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553/child/lines/80262",
			"name": "lines",
			"kind": "item"
		},
		{
			"rel": "canonical",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553/child/lines/80262",
			"name": "lines",
			"kind": "item"
		},
		{
			"rel": "parent",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553",
			"name": "purchaseRequisitions",
			"kind": "item"
		}
		]
	}
	],
	"count": 1,
	"hasMore": false,
	"limit": 25,
	"offset": 0,
	"links": [
	{
		"rel": "self",
		"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553/child/lines",
		"name": "lines",
		"kind": "collection"
	}
	]
}

Example 2 cURL Command

Use the following cURL command to submit a request on the REST resource to get all lines with specific attributes:

curl -u username:password "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553/child/lines?fields=LineNumber,CategoryName,ItemDescription,UOM,UnitPrice,AssignedBuyer,Supplier,Requester,DestinationType,DeliverToLocationCode,WorkOrder,WorkOrderProduct,RequestedShipDate,PurchaseOrder"

Example 2 Response Body

The following shows an example of the response body in JSON format.

{
	"items": [
	{
		"LineNumber": 1,
		"CategoryName": "Miscellaneous_1",
		"ItemDescription": "RAM - 512MB",
		"UnitPrice": 100,
		"UOM": "Each",
		"Supplier": null,
		"Requester": "Smith,Kurt",
		"AssignedBuyer": "Jones,Clare",
		"DestinationType": "Drop Ship",
		"DeliverToLocationCode": "Vision & Co.",
		"PurchaseOrder": "1004416",
		"WorkOrder": null,
		"WorkOrderProduct": null,
		"RequestedShipDate": "2051-05-18",
		"links": [
		{
			"rel": "self",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553/child/lines/80262",
			"name": "lines",
			"kind": "item"
		},
		{
			"rel": "canonical",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553/child/lines/80262",
			"name": "lines",
			"kind": "item"
		},
		{
			"rel": "parent",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553",
			"name": "purchaseRequisitions",
			"kind": "item"
		}
		]
	},
	{
		"LineNumber": 3,
		"CategoryName": "Miscellaneous_1",
		"ItemDescription": "PRC Custom Bicycle",
		"UnitPrice": 1585,
		"UOM": "Each",
		"Supplier": "CV_SuppA01",
		"Requester": "Smith,Kurt",
		"AssignedBuyer": "Jones,Clare",
		"DestinationType": "Inventory",
		"DeliverToLocationCode": "V1- New York City",
		"PurchaseOrder": null,
		"WorkOrder": null,
		"WorkOrderProduct": null,
		"RequestedShipDate": "2051-05-18",
		"links": [
		{
			"rel": "self",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553/child/lines/80264",
			"name": "lines",
			"kind": "item"
		},
		{
			"rel": "canonical",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553/child/lines/80264",
			"name": "lines",
			"kind": "item"
		},
		{
			"rel": "parent",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553",
			"name": "purchaseRequisitions",
			"kind": "item"
		}
		]
	},
	{
		"LineNumber": 2,
		"CategoryName": "Miscellaneous_1",
		"ItemDescription": "Outside Processing for Testing",
		"UnitPrice": 1000,
		"UOM": "Each",
		"Supplier": "CV_SuppA05",
		"Requester": "Smith,Kurt",
		"AssignedBuyer": "Jones,Clare",
		"DestinationType": "Work Order",
		"DeliverToLocationCode": "V1- New York City",
		"PurchaseOrder": null,
		"WorkOrder": "PORMFG10005 WorkOrder",
		"WorkOrderProduct": "ProductWO",
		"RequestedShipDate": "2051-05-18",
		"links": [
		{
			"rel": "self",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553/child/lines/80263",
			"name": "lines",
			"kind": "item"
		},
		{
			"rel": "canonical",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553/child/lines/80263",
			"name": "lines",
			"kind": "item"
		},
		{
			"rel": "parent",
			"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553",
			"name": "purchaseRequisitions",
			"kind": "item"
		}
		]
	}
	],
	"count": 3,
	"hasMore": false,
	"limit": 25,
	"offset": 0,
	"links": [
	{
		"rel": "self",
		"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/82553/child/lines",
		"name": "lines",
		"kind": "collection"
	}
	]
}
Back to Top