Tuesday, August 18, 2015

Sourcing Rule and Assignments Query in Advanced Supply Chain Planning ASCP Oracle Applications


SELECT sr.SOURCING_RULE_NAME,
       sr.organization_id,
       mp.organization_code ,
       sso.SR_RECEIPT_ID,
       sro.SOURCING_RULE_ID,
       sso.ALLOCATION_PERCENT,
       sso.CREATION_DATE,
       sso.LAST_UPDATE_DATE,
       sra.organization_id,
       sra.category_set_id,
       sra.inventory_item_id,
       msi.segment1
  FROM apps.MRP_SR_SOURCE_ORG_V sso,
       apps.MRP_SR_RECEIPT_ORG sro,
       apps.MRP_SOURCING_RULES sr,
       apps.MRP_SR_ASSIGNMENTS_V sra,
       apps.mtl_parameters mp,
       apps.mtl_system_items_b msi
 WHERE     sso.ALLOCATION_PERCENT != 100
       AND sso.ALLOCATION_PERCENT != 0
       AND sso.SR_RECEIPT_ID = sro.SR_RECEIPT_ID
       AND sro.SOURCING_RULE_ID = sr.SOURCING_RULE_ID
       and sso.SOURCE_TYPE = 1
       and sra.SOURCING_RULE_ID = sr.SOURCING_RULE_ID
       and sr.organization_id = mp.organization_id
       and msi.organization_id = 87
       and msi.inventory_item_id(+) = sra.inventory_item_id

No comments:

Post a Comment