Assignment
Set
SELECT ASSIGNMENT_SET_ID,ASSIGNMENT_SET_NAME,DESCRIPTION FROM MRP_ASSIGNMENT_SETS WHERE ASSIGNMENT_SET_ID = 231028
SELECT sourcing_rule_id, sourcing_rule_name, organization_id,
description, status,
sourcing_rule_type
,planning_active
FROM mrp_sourcing_rules WHERE description='TEST101'; --699950
Planning_active
(1=Yes,2=No)
SELECT sr_receipt_id, sourcing_rule_id, receipt_organization_id,
effective_date,
disable_date
FROM mrp_sr_receipt_org
WHERE sourcing_rule_id=699950;
SELECT sr_source_id, sr_receipt_id, source_organization_id, vendor_id,
vendor_site_id,
source_type, allocation_percent, rank
FROM mrp_sr_source_org
WHERE sr_receipt_id = 735891;
SELECT * FROM fnd_lookup_values WHERE lookup_type='MRP_SOURCING_RULE_TYPE'
SELECT sr_source_id, sr_receipt_id, source_organization_id, vendor_id,
vendor_site_id,
source_type, allocation_percent, rank
FROM mrp_sr_source_org
WHERE sr_receipt_id = 735894;
SELECT sr_source_id, sr_receipt_id, source_organization_id, vendor_id,
vendor_site_id,
source_type, allocation_percent, rank
FROM mrp_sr_source_org
WHERE sr_receipt_id = 735895;
Comments
Post a Comment