Queries

Query Oracle applications ERP apps

Sourcing Rule Assignments

Below query gives details of sourcing rules

Below query gives details of sourcing rule assignments. This does not consider Bill of distribution assignments. Also this query assumes that items are associated rather than item categories

Following query gives…

Consigned Inventory

    Consigned Inventory is used to manage material owned by Third party. So supplier places the inventory in customer’s store or warehouse and allows them to sell or consume it. Customer purchases the stock only after he resells the stock or…

Scheduled Programs Query

Below query gives the list of concurrent programs that are scheduled

For viewing more details about concurrent program, navigate to this link For viewing more details about concurrent requests, navigate to this link

Concurrent Request Queries

Below query gives the details of concurrent request(s)

For viewing more details about a concurrent program, navigate to this link

Concurrent Program Queries

Following queries gives details about concurrent program 1. Query to retrieve concurrent program or request set details

For viewing more details about concurrent request, navigate to this link 2. Query to retrieve the parameters for a concurrent program

BOM Explosion API

This blog details exploding a Bill of Material (BOM) for a model given a model number and organization code. It explodes the latest revision BOM. In case BOM of a prior revision has to be retrieved then l_rel_date variable can…

Users logged in the system

Following query gives the users who are logged into the system This query has 2 portions (1) Users who are using a form function (2) Users who are active since 1 minute