APPS.CSP_NOTIFICATIONS_PVT dependencies on CSP_SUP_DEM_PL_MV

Line 122: , CSP_SUP_DEM_PL_MV ccsds

118: , nvl(ccsds.onhand_good,0)
119: , nvl(cmsi.total_loop_min_good_quantity,0)
120: , nvl(cmsi.total_loop_quantity,0)
121: FROM csp_mstrstck_lists_itms cmsi
122: , CSP_SUP_DEM_PL_MV ccsds
123: WHERE cmsi.parts_loops_id = p_parts_loop_id
124: AND ccsds.parts_loop_id(+) = cmsi.parts_loops_id
125: AND cmsi.inventory_item_id = p_inventory_item_id
126: AND ccsds.inventory_item_id(+) = cmsi.inventory_item_id;