fr   en   
Login

Extract Sourcing Rules


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' ))
;

 
=

#2
Antonin: No not directly. You can track deliveries through purchasing module and see the difference in days betwen effective and expected receipt date.
#1
: Can we track the Purchasing history by delivery lead times?



backtotop