APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 1207: FROM mtl_system_items_b b, CSM_MTL_ONHAND_QTY_ACC acc,FND_USER usr ,asg_user au

1203: CURSOR c_parts(b_acc_id NUMBER)
1204: IS
1205: SELECT acc.USER_ID,usr.USER_NAME,usr.email_address,
1206: b.segment1 "ITEM_NAME",b.description,acc.SUBINVENTORY_CODE,acc.QUANTITY, b.primary_uom_code
1207: FROM mtl_system_items_b b, CSM_MTL_ONHAND_QTY_ACC acc,FND_USER usr ,asg_user au
1208: WHERE acc.access_id=b_acc_id
1209: AND b.inventory_item_id=acc.inventory_item_id
1210: AND b.organization_id=acc.organization_id
1211: AND usr.USER_ID=au.USER_ID