This view returns information on components and their associated assembly items. This information is displayed on the Planner Workbench Components window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a source instance code, a BOM component, a bill sequence, and an assembly item.

This view returns information on the critical activities of a plan. This information is displayed on the Critical Activities window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a demand order number, a supply order number, a critical item name, a critical path number, a demand priority number, a supply organization code, and a source instance code.

This view returns information about the details of the planned items for the manufacturing calendar dates on which a supply or demand transaction was performed. A record is returned for each combination of a plan name, an item name, an item category name, a category set name, a source instance code, a planned organization code, and a manufacturing calendar date

This view returns information on the demand details of a plan. This information is displayed on the Demand or Supply/Demand window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each demand transaction per plan.

This view returns information on the details of the different designators (names) defined as part of Supply Chain Planning and Advanced Supply Chain Planning. The designators created as part of Oracle Advanced Supply Chain Planning are displayed on the Supply Chain Plan Names window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a designator name, a source instance code, and an organization code.

This view returns information on the exception details generated by a plan. This information is displayed on the Exceptions Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan.

This view returns information on the forecast consumptions of a plan. This information is derived from the forecasts and sales orders information retrieved from the source systems and used in the Oracle Advanced Supply Chain Planning module of the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, an item name, a planned organization code, a forecast name, a sales order number, a sales order quantity, and a forecast quantity.

This view returns information on the categories of items that are used in plans. A record is returned for each category of an item.

This view returns information on the items that are being planned. This information is displayed on the Items window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a source instance code, a plan name, a planned organization code, and an item name.

This view returns the item exception details of a plan. This information is displayed on the Exceptions Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each item exception per plan.

This view returns summarized information on all item exceptions generated by a plan. This information is displayed on the Exceptions Summary window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a planned organization code, an exception group, an exception type, an item, a category set name, and an item category.

This view returns information on the substitute items to be considered for all planned items during the planning process. A record is returned for each substitute of a planned item as defined in the source inventory system.

This view returns information on the item supplier details of a plan. This information is displayed on the Supplier Capacity window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a supplier name, an item name, a plan name, a planned organization code, a source instance code, a supplier site, an item category name, a category set name, and a using organization code.

This view returns information on the late order exception details generated by a plan. This information is displayed on the Exception Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan.

The view returns information on dates of the manufacturing calendar periods. This information is displayed on the Calendar window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a source instance code, a manufacturing organization code, a manufacturing period name, a manufacturing period start date, a general ledger period start date, and a period set name.

This view returns information on the material and resource capacity exception details generated by a plan. This information is displayed on the Exception Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan.

The view returns information on the pegging details of a plan. This information is displayed on the Supply, Demand, and Supply/Demand windows of the Oracle Advance Supply Chain Planning module. A record is returned for each demand and the supply that is satisfying that demand.

This view returns information about the details of the planned items for the manufacturing periods during which a demand or supply transaction was performed. A record is returned for each combination of a plan name, an item name, an item category name, an item category description, a category set name, a source instance code, a planned organization code, and the start date of a manufacturing period.

This view returns information on supply chain plans and their options. This information is displayed on the Plan Options window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each plan.

This view returns information on the organizations that are being planned as part of a supply chain plan. This information is displayed on the Organizations tab of the Plan Options window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name and a planned organization code.

This view returns information on the reschedule exception details generated by a plan. This information is displayed on the Exception Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan, item, and item category.

This view returns information on the resources that are used in the planning process. This information is displayed on the Resources window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a source instance code, a planned organization, a department code, a resource description, and a resource code.

This view returns information on routing operations performed during the manufacturing of an assembly. This information is displayed on the Routing Operations window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a source instance code, a plan, a routing sequence, an operation sequence, and an operation component.

This view returns information on the resources associated with routing operations. This information is displayed on the Resources window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, an item name, a source instance code, a using assembly item, an operation sequence number, a planned organization code, a department code, a resource usage, an alternate routing designator, a resource code, and a routing type.

This view returns information on the required resources suggested by a plan. This information is displayed on the Resource Requirements window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a source instance code, a planned organization code, and a resource requirement.

This view returns information on the safety stock details of all the items. This information is displayed on the Safety Stock window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a source instance code, a plan name, a planned organization code, an item name, an effective start date of the safety stock, a planning group, a project number, a task number, and a demand unit number.

This view returns information on demand and supply schedules associated with a plan. This information is displayed on the Organizations tab of the Plan Options window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a planned organization code, and a schedule name.

This view returns information on sourcing rules and bills of distribution associated with the assignment set. This information is displayed on the Sourcing Rule / Bill of Distribution Assignments window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each assignment.

This view provides information on the sourcing rules and bills of distribution. This information is displayed on the Sourcing Rule or Bills of Distribution window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. For sourcing rules, a record is returned for each combination of a sourcing rule name, an effective start date, an effective end date, a shipping organization, a source type, a sourcing rank, a supplier name, and a supplier site. For bills of distribution, a record is returned for each combination of a sourcing rule name, a receiving organization, an effective start date, an effective end date, a source type, a sourcing rank, a supplier name, and a shipping organization.

The view returns information on the exceptions relating to substitutes and the alternates used for a plan. This information is displayed on the Exception Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan.

This view returns information on the supplier capacity details for all inventory items. This information is displayed on the Supplier Capacity window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a source instance code, a planned organization code, a supplier number, a supplier site, an item name, a category set, and an item category.

This view returns information on the details of supply chain bills. This information is displayed on the Supply Chain Bill window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan, organization, item or assembly item, component item description, and the item's sourcing information.

This view returns information on the supply details of a plan. This information is displayed on the Supply or Supply/Demand window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each supply transaction per plan.

This view returns information on the vertical plan details of the planned items. This information is displayed on the Vertical Plan window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for every demand or supply transaction per plan name, source instance code, planned organization code, item name, and due date.