Skip to content
  • fr

ERP Consultants

Tools and information for freelances

How to Extract Sourcing Rules in Oracle EBusiness Suite?

Posted on 7 April 20217 April 2021 By Antonin DUBOC No Comments on How to Extract Sourcing Rules in Oracle EBusiness Suite?

Use this request to extract sourcing rules from R11i or R12 instances.

Here are the tables used in this query:
MRP_SR_SOURCE_ORG;
MRP_SOURCING_RULES;
MRP_SR_RECEIPT_ORG;
AP_VENDORS_V;
po_vendor_sites_all;

SELECT
MRP_SOURCING_RULES.SOURCING_RULE_ID,
org_organization_definitions.organization_code,
MRP_SOURCING_RULES.SOURCING_RULE_NAME,
MRP_SOURCING_RULES.DESCRIPTION,
MRP_SOURCING_RULES.STATUS,
MRP_SOURCING_RULES.SOURCING_RULE_TYPE,
MRP_SOURCING_RULES.PLANNING_ACTIVE,
AP_VENDORS_V.VENDOR_NAME,
po_vendor_sites_all.VENDOR_SITE_CODE,
MRP_SR_SOURCE_ORG.RANK,
MRP_SR_SOURCE_ORG.ALLOCATION_PERCENT
FROM MRP_SOURCING_RULES
LEFT JOIN MRP_SR_RECEIPT_ORG_V ON MRP_SR_RECEIPT_ORG_V.SOURCING_RULE_ID=MRP_SOURCING_RULES.SOURCING_RULE_ID
LEFT JOIN MRP_SR_SOURCE_ORG ON MRP_SR_SOURCE_ORG.SR_RECEIPT_ID=MRP_SR_RECEIPT_ORG_V.SR_RECEIPT_ID
LEFT JOIN AP_VENDORS_V ON AP_VENDORS_V.VENDOR_ID=MRP_SR_SOURCE_ORG.VENDOR_ID
LEFT JOIN po_vendor_sites_all ON po_vendor_sites_all.VENDOR_SITE_ID=MRP_SR_SOURCE_ORG.VENDOR_SITE_ID
LEFT JOIN org_organization_definitions ON org_organization_definitions.ORGANIZATION_ID=MRP_SOURCING_RULES.ORGANIZATION_ID
WHERE 1=1
AND MRP_SOURCING_RULES.ORGANIZATION_ID IN (select organization_id from org_organization_definitions where (organization_code = 'XXX' OR organization_code = 'XXY' ))
;
OBS Tags:Purchasing, SQL, Supply-Chain

Post navigation

Previous Post: How to define constraint-based plans in Oracle EBusiness Suite?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Tags

Forecast Lead times Manufacturing MRP OBS Order Management Planning Purchasing Sales order SQL Supply-Chain

Calendar

April 2021
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
     

Publicité

Copyright © 2021 ERP Consultants.

Powered by PressBook WordPress theme