VIEW: APPS.MSC_DRP_ITEM_ALLOC_V

Source

View Text - Preformatted

SELECT mdalv.assignment_set_id ,mdalv.allocation_rule_id ,mdalv.INVENTORY_ITEM_ID ,mdalv.ORGANIZATION_ID ,mdalv.SR_INSTANCE_ID ,areceipt.TO_ORGANIZATION_ID ,areceipt.SR_INSTANCE_ID ,ardates.EFFECTIVE_DATE ,ardates.DISABLE_DATE ,areceipt.DMD_PRIORITY ,areceipt.RANK ,areceipt.ALLOCATION_PERCENT ,areceipt.FIXED_LOT_MULTIPLIER ,ardates.DMD_PRI_OVERRIDE ,ardates.FAIR_SHARE_ALLOC ,areceipt.MIN_ORDER_QTY ,areceipt.MAX_ORDER_QTY from msc_drp_alloc_levels_v mdalv , msc_drp_alloc_rules arules , msc_drp_alloc_rule_dates ardates , msc_drp_alloc_receipt_rules areceipt , msc_assignment_sets mas WHERE mas.assignment_set_id = mdalv.assignment_set_id and mdalv.allocation_rule_id = arules.rule_id and arules.planning_active = 'Y' and arules.rule_id = ardates.rule_id and ardates.time_phase_id = areceipt.time_phase_id and mdalv.assignment_level = (select min(assignment_level) from msc_drp_alloc_levels_v mdalv1 where mdalv.inventory_item_id = mdalv1.inventory_item_id and mdalv.organization_id = mdalv1.organization_id and mdalv.sr_instance_id = mdalv1.sr_instance_id and mas.assignment_set_id = mdalv1.assignment_set_id)

View Text - HTML Formatted

SELECT MDALV.ASSIGNMENT_SET_ID
, MDALV.ALLOCATION_RULE_ID
, MDALV.INVENTORY_ITEM_ID
, MDALV.ORGANIZATION_ID
, MDALV.SR_INSTANCE_ID
, ARECEIPT.TO_ORGANIZATION_ID
, ARECEIPT.SR_INSTANCE_ID
, ARDATES.EFFECTIVE_DATE
, ARDATES.DISABLE_DATE
, ARECEIPT.DMD_PRIORITY
, ARECEIPT.RANK
, ARECEIPT.ALLOCATION_PERCENT
, ARECEIPT.FIXED_LOT_MULTIPLIER
, ARDATES.DMD_PRI_OVERRIDE
, ARDATES.FAIR_SHARE_ALLOC
, ARECEIPT.MIN_ORDER_QTY
, ARECEIPT.MAX_ORDER_QTY
FROM MSC_DRP_ALLOC_LEVELS_V MDALV
, MSC_DRP_ALLOC_RULES ARULES
, MSC_DRP_ALLOC_RULE_DATES ARDATES
, MSC_DRP_ALLOC_RECEIPT_RULES ARECEIPT
, MSC_ASSIGNMENT_SETS MAS
WHERE MAS.ASSIGNMENT_SET_ID = MDALV.ASSIGNMENT_SET_ID
AND MDALV.ALLOCATION_RULE_ID = ARULES.RULE_ID
AND ARULES.PLANNING_ACTIVE = 'Y'
AND ARULES.RULE_ID = ARDATES.RULE_ID
AND ARDATES.TIME_PHASE_ID = ARECEIPT.TIME_PHASE_ID
AND MDALV.ASSIGNMENT_LEVEL = (SELECT MIN(ASSIGNMENT_LEVEL)
FROM MSC_DRP_ALLOC_LEVELS_V MDALV1
WHERE MDALV.INVENTORY_ITEM_ID = MDALV1.INVENTORY_ITEM_ID
AND MDALV.ORGANIZATION_ID = MDALV1.ORGANIZATION_ID
AND MDALV.SR_INSTANCE_ID = MDALV1.SR_INSTANCE_ID
AND MAS.ASSIGNMENT_SET_ID = MDALV1.ASSIGNMENT_SET_ID)