Get one item

get

/fscmRestApi/resources/11.13.18.05/itemsLOV

Request

Query Parameters
  • 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 Get all items
      Finder Variables
      • ItemId; integer; Value that uniquely identifies the organization. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
      • OrganizationId; integer; Find items according to the specified primary key criteria.
  • 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:
    • AllowMaintenanceAssetFlag; boolean; Contains one of the following values: true or false. If true, then maintainable assets can be defined for the item. If false, then maintainable assets can't be defined for the item. The default value is false.
    • ApprovalStatus; string; Approval status of the item. A list of accepted values is defined in the lookup type EGP_APPROVAL_STATUS. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
    • AssembleToOrderFlag; boolean; Contains one of the following values: true or false. If true, the item is built for sales order demand and a final assembly work order is created based on sales order details. If false, then the assembly work order isn't created for the item. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • AssetTrackedFlag; boolean; Contains one of the following values: true or false. If true, then the item is classified as an asset item. If false, then the item isn't classified as an asset item. The default value is false. For a list of attribute value interdependencies, refer to Interdependent Item Attributes: Explained at: https://www.oracle.com/pls/topic/lookup?ctx=cloud&id=FAPIM287169.
    • AutoCreatedConfigurationFlag; boolean; Contains one of the following values: true or false. If true, then the item is created automatically. If false, then the item isn't created automatically. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • BOMItemType; number; Value that indicates the type of bill of material that the item can have. Values include standard, model, and planning. A list of accepted values is defined in the lookup type EGP_BOM_ITEM_TYPE. Review the value for this attribute using the Manage Standard Lookups task in the Setup and Maintenance work area. The default value is 4. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
    • BackToBackEnabledFlag; boolean; Contains one of the following values: true or false. If true, then enable the item for back-to-back ordering. If false, then don't enable the item for back-to-back ordering. The default value is false. For a list of attribute value interdependencies, refer to Interdependent Item Attributes.
    • BaseItemId; integer; Value that uniquely identifies the model to use when creating an assemble-to-order configuration. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • CreateFixedAsset; string; Contains one of the following values: true or false. If true, then create a depreciable inventory asset for the item when using the installed base. If false, then don't track. The default value is false. For a list of attribute value interdependencies, refer to Interdependent Item Attributes: Explained at: https://www.oracle.com/pls/topic/lookup?ctx=cloud&id=FAPIM287169.
    • CreatedBy; string; Name of the user who created the item.
    • CreationDate; string; Date when the user created the item.
    • CurrentPhaseCode; string; Abbreviation that identifies the lifecycle phase of the item. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Lifecycle Phases task.
    • CustomerOrderEnabledFlag; boolean; Contains one of the following values: true or false. If true, then the item can be ordered by external customers at this time. If false, then the item can't be ordered by external customers at this time. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • CustomerOrderFlag; boolean; Value that indicates whether to allow an item to be ordered by external customers. Contains one of the following values: true or false. If true, then the item can be ordered by external customers. If false, then the item can't be ordered by external customers. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • EffectivityControl; number; Value that indicates how to calculate the lead time based on Date, Model, or Unit Number. A list of accepted values is defined in the lookup type EGP_BOM_EFFEC_CTRL. Review the value for this attribute using the Manage Standard Lookups task in the Setup and Maintenance work area. The default value is 1. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • EnableGenealogyTrackingFlag; boolean; Contains one of the following values: true or false. If true, then the item is enabled for genealogy tracking. If false, then the item isn't enabled for genealogy tracking. The default value is false.
    • EnableIotFlag; boolean; Contains one of the following values: True or False. If True, then the asset can be enabled for Internet of Things (IoT). If False, then the asset can't be enabled for IoT. The default value is False.
    • InternallyTransferableFlag; boolean; Contains one of the following values: true or false. If true, then the item can be ordered by internal customers. If false, then the item can't be ordered by internal customers. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • InventoryItemStatusCode; string; Abbreviation that identifies the item status. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Statuses task.
    • ItemClass; string; Name of the item class. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Classes task.
    • ItemClassId; integer; Value that uniquely identifies the item class.
    • ItemDefinitionOrgId; integer; Value that uniquely identifies the definition organization associated with the item.
    • ItemDescription; string; Description of the part, item, product, or service.
    • ItemId; integer; Value that uniquely identifies the part, item, product, or service.
    • ItemNumber; string; Name or number of the part, item, product, or service.
    • ItemStatusValue; string; Value that identifies the item status. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Statuses task.
    • ItemType; string; Type of the item. A list of accepted values is defined in the lookup type EGP_ITEM_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
    • Keyword; string; Value that represents a string of characters used for searching using keywords.
    • LastUpdateDate; string; Date and time when the user most recently updated the item.
    • LastUpdatedBy; string; User who most recently updated the item.
    • LotControlCode; number; Value that indicates the ability to use lot numbers during material transactions for tracking of batches of Item. A list of accepted values is defined in the lookup type EGP_LOT_CONTROL_CODE_TYPE. Review the value for this attribute using the Manage Standard Lookups task in the Setup and Maintenance work area.
    • MaterialTransactionEnabledFlag; boolean; Contains one of the following values: true or false. If true, then transactions can be performed on the item. If false, then transactions can't be performed on the item. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • OrderManagementIndivisibleFlag; boolean; Contains one of the following values: true or false. If true, then allow orders in fractions of an item. If false, then don't allow orders in fractions of an item. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide
    • OrganizationCode; string; Abbreviation that identifies the organization. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
    • OrganizationId; integer; Value that uniquely identifies the organization. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
    • OutsideProcessServiceFlag; boolean; Contains one of the following values: true or false. If true, then the item can be added to an outside processing purchase order. If false, then the item can't be added to an outside processing purchase order. The default value is false.
    • PickComponentsFlag; boolean; Contains one of the following values: true or false. If true, then items can be picked from the finished goods inventory. If false, then items can't be picked from the finished goods inventory. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • PlanningMethodValue; string; Value that indicates the type of planning that's used for the item. A list of accepted values is defined in the lookup type EGP_MATERIAL_PLANNING. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is set to Not Planned.
    • PrimaryImageURL; string; Indicates the attachment URL for the primary image of the item.
    • PrimaryUOMCode; string; Abbreviation that identifies the unit of measure that's used to determine pricing for an item. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Unit of Measures task.
    • RequestId; integer; Value that uniquely identifies the scheduled process that created the item.
    • RestrictSubinventoriesFlag; boolean; Contains one of the following values: True or False. If True, then restrict the transactions of the item from the subinventory. If False, then don't restrict the transactions of the item from the subinventory. The default value is True. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • RevisionQuantityControlFlag; boolean; Contains one of the following values: true or false. If true, then the item is under revision control and it includes inventory attributes. If false, then the item isn't under revision control and it includes inventory attributes. The default value is False. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • SalesProductType; string; Value that indicates the sales product type. Domain values include Goods, Subscription, Coverage, and Training. A list of accepted values is defined in the lookup type QSC_SALES_PRODUCT_TYPE. Review the value for this attribute using the Manage Standard Lookups task in the Setup and Maintenance work area. The default value is Goods. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • SerialGenerationValue; string; Value that indicates the number assigned to each unit of an item and is used to track the item. A list of accepted values is defined in the lookup type EGP_SERIAL_NUMBER_CONTROL_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1. For a list of attribute value interdependencies, refer to Interdependent Item Attributes.
    • SerialNumberControlCode; number; Value that identifies the number assigned to each unit of an item and is used to track the item. A list of accepted values is defined in the lookup type EGP_SERIAL_NUMBER_CONTROL_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1.
    • ServiceableProductFlag; boolean; Contains one of the following values: true or false. If true, then the item is eligible to be covered in a service contract. If false, then the item isn't eligible to be covered in a service contract. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • ShippableFlag; boolean; Contains one of the following values: true or false. If true, then the application can ship the item to the customer. If false, then the application can't ship the item, for example, if the item is a service agreement. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • StockEnabledFlag; boolean; Contains one of the following values: true or false. If true, then the item can be stocked in inventory. If false, then the item can't be stocked in inventory. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • TransactionEnabledFlag; boolean; Contains one of the following values: true or false. If true, then transactions can be performed on the item. If false, then transactions can't be performed on the item. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • TransferOrdersEnabledFlag; boolean; Contains one of the following values: true or false. If true, then the item can be ordered on an internal requisition. If false, then item can't be ordered based on an internal requisition. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
    • UserItemTypeValue; string; Type of the item. A list of accepted values is defined in the lookup type EGP_ITEM_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
  • 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 : itemsLOV
Type: object
Show Source
Nested Schema : Items
Type: array
Title: Items
The items in the collection.
Show Source
Nested Schema : itemsLOV-item-response
Type: object
Show Source
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then maintainable assets can be defined for the item. If false, then maintainable assets can't be defined for the item. The default value is false.
  • Read Only: true
    Maximum Length: 30
    Approval status of the item. A list of accepted values is defined in the lookup type EGP_APPROVAL_STATUS. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, the item is built for sales order demand and a final assembly work order is created based on sales order details. If false, then the assembly work order isn't created for the item. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item is classified as an asset item. If false, then the item isn't classified as an asset item. The default value is false. For a list of attribute value interdependencies, refer to Interdependent Item Attributes: Explained at: https://www.oracle.com/pls/topic/lookup?ctx=cloud&id=FAPIM287169.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item is created automatically. If false, then the item isn't created automatically. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then enable the item for back-to-back ordering. If false, then don't enable the item for back-to-back ordering. The default value is false. For a list of attribute value interdependencies, refer to Interdependent Item Attributes.
  • Value that uniquely identifies the model to use when creating an assemble-to-order configuration. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Value that indicates the type of bill of material that the item can have. Values include standard, model, and planning. A list of accepted values is defined in the lookup type EGP_BOM_ITEM_TYPE. Review the value for this attribute using the Manage Standard Lookups task in the Setup and Maintenance work area. The default value is 4. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Maximum Length: 64
    Name of the user who created the item.
  • Maximum Length: 30
    Contains one of the following values: true or false. If true, then create a depreciable inventory asset for the item when using the installed base. If false, then don't track. The default value is false. For a list of attribute value interdependencies, refer to Interdependent Item Attributes: Explained at: https://www.oracle.com/pls/topic/lookup?ctx=cloud&id=FAPIM287169.
  • Read Only: true
    Date when the user created the item.
  • Cross-Reference Relationships
    Title: Cross-Reference Relationships
    The Cross-Reference Relationships resource manages the relationship between an internal item and item cross-references.
  • Read Only: true
    Maximum Length: 120
    Abbreviation that identifies the lifecycle phase of the item. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Lifecycle Phases task.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item can be ordered by external customers at this time. If false, then the item can't be ordered by external customers at this time. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Maximum Length: 1
    Value that indicates whether to allow an item to be ordered by external customers. Contains one of the following values: true or false. If true, then the item can be ordered by external customers. If false, then the item can't be ordered by external customers. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Value that indicates how to calculate the lead time based on Date, Model, or Unit Number. A list of accepted values is defined in the lookup type EGP_BOM_EFFEC_CTRL. Review the value for this attribute using the Manage Standard Lookups task in the Setup and Maintenance work area. The default value is 1. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item is enabled for genealogy tracking. If false, then the item isn't enabled for genealogy tracking. The default value is false.
  • Maximum Length: 1
    Contains one of the following values: True or False. If True, then the asset can be enabled for Internet of Things (IoT). If False, then the asset can't be enabled for IoT. The default value is False.
  • GTIN Relationships
    Title: GTIN Relationships
    The GTIN Relationships resource manages the relationship between an internal item and GTIN.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item can be ordered by internal customers. If false, then the item can't be ordered by internal customers. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Read Only: true
    Maximum Length: 10
    Abbreviation that identifies the item status. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Statuses task.
  • Item Categories
    Title: Item Categories
    The association of a category to a catalog or a child category to a parent category, such as the association of the Televisions category to the Summer catalog or to the Electronics category.
  • Title: Item Class
    Read Only: true
    Maximum Length: 250
    Name of the item class. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Classes task.
  • Read Only: true
    Value that uniquely identifies the item class.
  • Read Only: true
    Value that uniquely identifies the definition organization associated with the item.
  • Read Only: true
    Maximum Length: 240
    Description of the part, item, product, or service.
  • ItemDFF
    The Descriptive Flexfield for Items List of Values resource gets the descriptive flexfields associated with the item object.
  • Read Only: true
    Value that uniquely identifies the part, item, product, or service.
  • Read Only: true
    Maximum Length: 300
    Name or number of the part, item, product, or service.
  • Read Only: true
    Maximum Length: 255
    Value that identifies the item status. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Statuses task.
  • Read Only: true
    Maximum Length: 30
    Type of the item. A list of accepted values is defined in the lookup type EGP_ITEM_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
  • Read Only: true
    Maximum Length: 1000
    Value that represents a string of characters used for searching using keywords.
  • Read Only: true
    Date and time when the user most recently updated the item.
  • Maximum Length: 64
    User who most recently updated the item.
  • Links
  • Value that indicates the ability to use lot numbers during material transactions for tracking of batches of Item. A list of accepted values is defined in the lookup type EGP_LOT_CONTROL_CODE_TYPE. Review the value for this attribute using the Manage Standard Lookups task in the Setup and Maintenance work area.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then transactions can be performed on the item. If false, then transactions can't be performed on the item. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then allow orders in fractions of an item. If false, then don't allow orders in fractions of an item. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide
  • Read Only: true
    Maximum Length: 18
    Abbreviation that identifies the organization. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
  • Read Only: true
    Value that uniquely identifies the organization. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item can be added to an outside processing purchase order. If false, then the item can't be added to an outside processing purchase order. The default value is false.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then items can be picked from the finished goods inventory. If false, then items can't be picked from the finished goods inventory. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Read Only: true
    Maximum Length: 255
    Value that indicates the type of planning that's used for the item. A list of accepted values is defined in the lookup type EGP_MATERIAL_PLANNING. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is set to Not Planned.
  • Maximum Length: 4000
    Indicates the attachment URL for the primary image of the item.
  • Read Only: true
    Maximum Length: 3
    Abbreviation that identifies the unit of measure that's used to determine pricing for an item. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Unit of Measures task.
  • Related Item Relationships
    Title: Related Item Relationships
    The Related Item Relationships resource manages relationship between two items.
  • Value that uniquely identifies the scheduled process that created the item.
  • Contains one of the following values: True or False. If True, then restrict the transactions of the item from the subinventory. If False, then don't restrict the transactions of the item from the subinventory. The default value is True. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Contains one of the following values: true or false. If true, then the item is under revision control and it includes inventory attributes. If false, then the item isn't under revision control and it includes inventory attributes. The default value is False. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Maximum Length: 30
    Value that indicates the sales product type. Domain values include Goods, Subscription, Coverage, and Training. A list of accepted values is defined in the lookup type QSC_SALES_PRODUCT_TYPE. Review the value for this attribute using the Manage Standard Lookups task in the Setup and Maintenance work area. The default value is Goods. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Read Only: true
    Maximum Length: 255
    Value that indicates the number assigned to each unit of an item and is used to track the item. A list of accepted values is defined in the lookup type EGP_SERIAL_NUMBER_CONTROL_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1. For a list of attribute value interdependencies, refer to Interdependent Item Attributes.
  • Value that identifies the number assigned to each unit of an item and is used to track the item. A list of accepted values is defined in the lookup type EGP_SERIAL_NUMBER_CONTROL_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item is eligible to be covered in a service contract. If false, then the item isn't eligible to be covered in a service contract. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the application can ship the item to the customer. If false, then the application can't ship the item, for example, if the item is a service agreement. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Spoke System Item Relationships
    Title: Spoke System Item Relationships
    The Spoke System Item Relationships resource manages the relationship between an internal item and spoke system item.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item can be stocked in inventory. If false, then the item can't be stocked in inventory. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Trading Partner Item Relationships
    Title: Trading Partner Item Relationships
    The Trading Partner Item Relationships resource manages the trading partner item relationships that are relationships between internal items and trading partner items.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then transactions can be performed on the item. If false, then transactions can't be performed on the item. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item can be ordered on an internal requisition. If false, then item can't be ordered based on an internal requisition. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Using Product Master Data Management guide.
  • Read Only: true
    Maximum Length: 255
    Type of the item. A list of accepted values is defined in the lookup type EGP_ITEM_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
Nested Schema : Cross-Reference Relationships
Type: array
Title: Cross-Reference Relationships
The Cross-Reference Relationships resource manages the relationship between an internal item and item cross-references.
Show Source
Nested Schema : GTIN Relationships
Type: array
Title: GTIN Relationships
The GTIN Relationships resource manages the relationship between an internal item and GTIN.
Show Source
Nested Schema : Item Categories
Type: array
Title: Item Categories
The association of a category to a catalog or a child category to a parent category, such as the association of the Televisions category to the Summer catalog or to the Electronics category.
Show Source
Nested Schema : ItemDFF
Type: array
The Descriptive Flexfield for Items List of Values resource gets the descriptive flexfields associated with the item object.
Show Source
Nested Schema : Related Item Relationships
Type: array
Title: Related Item Relationships
The Related Item Relationships resource manages relationship between two items.
Show Source
Nested Schema : Spoke System Item Relationships
Type: array
Title: Spoke System Item Relationships
The Spoke System Item Relationships resource manages the relationship between an internal item and spoke system item.
Show Source
Nested Schema : Trading Partner Item Relationships
Type: array
Title: Trading Partner Item Relationships
The Trading Partner Item Relationships resource manages the trading partner item relationships that are relationships between internal items and trading partner items.
Show Source
Nested Schema : itemsLOV-CrossReferenceRelationships-item-response
Type: object
Show Source
Nested Schema : itemsLOV-GTINRelationships-item-response
Type: object
Show Source
Nested Schema : itemsLOV-ItemCategories-item-response
Type: object
Show Source
Nested Schema : itemsLOV-ItemDFF-item-response
Type: object
Show Source
Nested Schema : itemsLOV-RelatedItemRelationships-item-response
Type: object
Show Source
Nested Schema : itemsLOV-SpokeSystemItemRelationships-item-response
Type: object
Show Source
Nested Schema : itemsLOV-TradingPartnerItemRelationships-item-response
Type: object
Show Source
Back to Top