Kanban is a means of supporting pull-based replenishment in manufacturing systems. A Kanban system is a self-regulating pull system that leads to shorter lead times and reduced inventory. Kanban systems are typically applied to items that have relatively constant demand…
Uncategorized
Discrete Job – Outside Processing
by tvravikanth • • 0 Comments
This post covers the entire business process for outside processing. In case of Manufacturing, outside processing job can be one operation among several operations for making a finished good. To simplify the business case I am considering only 1 operation…
Uncategorized
Supplier Scheduling
by tvravikanth • • 0 Comments
Supplier scheduling is used to calculate, maintain and communicate planning and shipping schedules to your supplier partners. Planning schedules are used to convey long-range requirement forecasts, and to optionally include order releases and material authorizations, which are commitments to fund…
Supply Chain
Inventory Optimization
by tvravikanth • • 0 Comments
Following steps gives details of setting up an Inventory Optimization plan. For setting up Inventory optimization plan, we first need to have items classified under ABC groups. Define ABC Classes ABC classes to identify the value groupings to which…
Queries
Sourcing Rule Assignments
by tvravikanth • • 0 Comments
Below query gives details of sourcing rules
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
select msr.sourcing_rule_id ,msr.sourcing_rule_name ,msr.description ,pv.vendor_name ,pvs.vendor_site_code ,ood.organization_name source_organization_name ,msso.allocation_percent ,msso.rank ,msso.ship_method ,msro.effective_date from_date ,msro.disable_date to_date from mrp_sr_source_org msso ,mrp_sr_receipt_org msro ,mrp_sourcing_rules msr ,org_organization_definitions ood ,po_vendors pv ,po_vendor_sites_all pvs where 1=1 and msro.sr_receipt_id = msso.sr_receipt_id and msr.sourcing_rule_id = msro.sourcing_rule_id and ood.organization_id(+) = msso.source_organization_id and pv.vendor_id(+) = msso.vendor_id and pvs.vendor_site_id(+) = msso.vendor_site_id and msr.sourcing_rule_name like :sourcing_rule_name -- and ood.organization_code(+) = :organization_code -- and pv.vendor_name = :vendor_name |
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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
select mas.assignment_set_name ,ood.organization_name organization ,hp.party_name customer ,hl.address1 customer_site ,msi.segment1 item_name ,msr.sourcing_rule_name from mrp_sr_assignments msa ,mrp_assignment_sets mas ,mrp_sourcing_rules msr ,mtl_system_items msi ,org_organization_definitions ood ,hz_cust_accounts hca ,hz_parties hp ,hz_cust_site_uses_all hcsu ,hz_cust_acct_sites_all hcas ,hz_party_sites hps ,hz_locations hl where 1=1 and mas.assignment_set_id = msa.assignment_set_id and msa.sourcing_rule_type = 1 --Sourcing Rule Type and msr.sourcing_rule_id = msa.sourcing_rule_id and msi.inventory_item_id = msa.inventory_item_id and msi.organization_id = fnd_profile.value('QP_ORGANIZATION_ID') --Use some profile which return master org and ood.organization_id(+) = msa.organization_id and hca.cust_account_id(+) = msa.customer_id and hp.party_id(+) = hca.party_id and hcsu.site_use_id(+) = msa.ship_to_site_id and hcas.cust_acct_site_id(+) = hcsu.cust_acct_site_id and hps.party_site_id(+) = hcas.party_site_id and hl.location_id(+) = hps.location_id and mas.assignment_set_name = :assignment_set_name --and msr.sourcing_rule_name like :sourcing_rule_name and msi.segment1 like :item_name and rownum < 10 |
Following query gives…
Queries, Supply Chain
Consigned Inventory
by tvravikanth • • 0 Comments
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…