VIEW: APPS.MSC_DRP_ITEM_ALLOCATIONS_V

Source

View Text - Preformatted

SELECT mdia.plan_id , ORGS.ORGANIZATION_ID , orgs.sr_instance_id , MDIA.INVENTORY_ITEM_ID , ITEM.item_name , MDIA.SRC_ORGANIZATION_ID , mdia.src_sr_instance_id , msc_get_name.org_code(mdia.src_organization_id,mdia.src_sr_instance_id) , MDIA.ORGANIZATION_ID , mdia.sr_instance_id , msc_get_name.org_code(mdia.organization_id,mdia.sr_instance_id) , MDIA.EFFECTIVE_DATE , MDIA.DISABLE_DATE , MDIA.ALLOCATION_PERCENT , MDIA.RANK , MDIA.ALLOCATION_RULE_ID , RULES.NAME , RULES.DESCRIPTION , MDIA.FAIR_SHARE_ALLOC , msc_get_name.lookup_meaning('MSC_DRP_ALLOC_RULE_TYPE', MDIA.FAIR_SHARE_ALLOC) , Mss.ASSIGNMENT_ID , MDIA.ASSIGNMENT_SET_ID , Mss.ASSIGNMENT_TYPE , msc_get_name.lookup_meaning('MRP_SR_ASSIGNMENT_TYPE',mss.assignment_type) , MDIA.DMD_PRI_OVERRIDE , msc_get_name.lookup_meaning('MSC_DRP_DMD_PRI_OVERRIDE',MDIA.DMD_PRI_OVERRIDE) , MDIA.DMD_PRIORITY , MDIA.ORDER_SIZE , cat.category_set_id , cat.sr_category_id , MDIA.LAST_UPDATED_BY , MDIA.LAST_UPDATE_DATE , MDIA.CREATED_BY , MDIA.CREATION_DATE , MDIA.LAST_UPDATE_LOGIN ,MDIA.MIN_ORDER_QTY ,MDIA.MAX_ORDER_QTY FROM Msc_drp_ALLOC_RULES RULES, Msc_items ITEM, Msc_DRP_ITEM_ALLOCATIONS mdia, msc_sr_assignments mss, Msc_plans ORGS, MSC_ITEM_Categories CAT WHERE RULES.RULE_ID(+) = mdia.ALLOCATION_RULE_ID AND ITEM.INVENTORY_ITEM_ID = mdia.INVENTORY_ITEM_ID AND mdia.plan_id = ORGS.plan_id AND CAT.inventory_item_id = mdia.inventory_item_id AND CAT.sr_instance_id = mdia.sr_instance_id AND CAT.organization_id = mdia.src_organization_id AND mss.assignment_set_id(+) = mdia.assignment_set_id AND mss.allocation_rule_id(+) = mdia.allocation_rule_id AND mss.organization_id(+) = mdia.src_organization_id

View Text - HTML Formatted

SELECT MDIA.PLAN_ID
, ORGS.ORGANIZATION_ID
, ORGS.SR_INSTANCE_ID
, MDIA.INVENTORY_ITEM_ID
, ITEM.ITEM_NAME
, MDIA.SRC_ORGANIZATION_ID
, MDIA.SRC_SR_INSTANCE_ID
, MSC_GET_NAME.ORG_CODE(MDIA.SRC_ORGANIZATION_ID
, MDIA.SRC_SR_INSTANCE_ID)
, MDIA.ORGANIZATION_ID
, MDIA.SR_INSTANCE_ID
, MSC_GET_NAME.ORG_CODE(MDIA.ORGANIZATION_ID
, MDIA.SR_INSTANCE_ID)
, MDIA.EFFECTIVE_DATE
, MDIA.DISABLE_DATE
, MDIA.ALLOCATION_PERCENT
, MDIA.RANK
, MDIA.ALLOCATION_RULE_ID
, RULES.NAME
, RULES.DESCRIPTION
, MDIA.FAIR_SHARE_ALLOC
, MSC_GET_NAME.LOOKUP_MEANING('MSC_DRP_ALLOC_RULE_TYPE'
, MDIA.FAIR_SHARE_ALLOC)
, MSS.ASSIGNMENT_ID
, MDIA.ASSIGNMENT_SET_ID
, MSS.ASSIGNMENT_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_SR_ASSIGNMENT_TYPE'
, MSS.ASSIGNMENT_TYPE)
, MDIA.DMD_PRI_OVERRIDE
, MSC_GET_NAME.LOOKUP_MEANING('MSC_DRP_DMD_PRI_OVERRIDE'
, MDIA.DMD_PRI_OVERRIDE)
, MDIA.DMD_PRIORITY
, MDIA.ORDER_SIZE
, CAT.CATEGORY_SET_ID
, CAT.SR_CATEGORY_ID
, MDIA.LAST_UPDATED_BY
, MDIA.LAST_UPDATE_DATE
, MDIA.CREATED_BY
, MDIA.CREATION_DATE
, MDIA.LAST_UPDATE_LOGIN
, MDIA.MIN_ORDER_QTY
, MDIA.MAX_ORDER_QTY
FROM MSC_DRP_ALLOC_RULES RULES
, MSC_ITEMS ITEM
, MSC_DRP_ITEM_ALLOCATIONS MDIA
, MSC_SR_ASSIGNMENTS MSS
, MSC_PLANS ORGS
, MSC_ITEM_CATEGORIES CAT
WHERE RULES.RULE_ID(+) = MDIA.ALLOCATION_RULE_ID
AND ITEM.INVENTORY_ITEM_ID = MDIA.INVENTORY_ITEM_ID
AND MDIA.PLAN_ID = ORGS.PLAN_ID
AND CAT.INVENTORY_ITEM_ID = MDIA.INVENTORY_ITEM_ID
AND CAT.SR_INSTANCE_ID = MDIA.SR_INSTANCE_ID
AND CAT.ORGANIZATION_ID = MDIA.SRC_ORGANIZATION_ID
AND MSS.ASSIGNMENT_SET_ID(+) = MDIA.ASSIGNMENT_SET_ID
AND MSS.ALLOCATION_RULE_ID(+) = MDIA.ALLOCATION_RULE_ID
AND MSS.ORGANIZATION_ID(+) = MDIA.SRC_ORGANIZATION_ID