APPS.WMS_REPLENISHMENT_PVT dependencies on MTL_ABC_ASSIGNMENTS

Line 2190: /*10131943- Made the query on MTL_ABC_ASSIGNMENTS a sub-query because an item can have multiple ABC compile/group assignments*/

2186: --Exclude those demands that have suub
2187: -- specified, we can not use sub = Forward_pick_sub either
2188: -- becs FP sub info is not availble while marking 'RC' at the pick drop time when rsv = N
2189: AND wdd.subinventory IS NULL
2190: /*10131943- Made the query on MTL_ABC_ASSIGNMENTS a sub-query because an item can have multiple ABC compile/group assignments*/
2191: AND (NOT EXISTS (SELECT 1
2192: FROM mtl_abc_assignments maa
2193: WHERE maa.inventory_item_id = oel.inventory_item_id)
2194: OR EXISTS (SELECT 1

Line 2192: FROM mtl_abc_assignments maa

2188: -- becs FP sub info is not availble while marking 'RC' at the pick drop time when rsv = N
2189: AND wdd.subinventory IS NULL
2190: /*10131943- Made the query on MTL_ABC_ASSIGNMENTS a sub-query because an item can have multiple ABC compile/group assignments*/
2191: AND (NOT EXISTS (SELECT 1
2192: FROM mtl_abc_assignments maa
2193: WHERE maa.inventory_item_id = oel.inventory_item_id)
2194: OR EXISTS (SELECT 1
2195: FROM mtl_abc_assignments maa
2196: WHERE maa.inventory_item_id = oel.inventory_item_id

Line 2195: FROM mtl_abc_assignments maa

2191: AND (NOT EXISTS (SELECT 1
2192: FROM mtl_abc_assignments maa
2193: WHERE maa.inventory_item_id = oel.inventory_item_id)
2194: OR EXISTS (SELECT 1
2195: FROM mtl_abc_assignments maa
2196: WHERE maa.inventory_item_id = oel.inventory_item_id
2197: AND Nvl(maa.assignment_group_id, -1) = Nvl(p_ABC_assignment_group_id, Nvl(maa.assignment_group_id, -1))
2198: AND Nvl(maa.abc_class_id, -1) = Nvl(p_abc_class_id, Nvl(maa.abc_class_id, -1))
2199: )