APPS.GMD_STATUS_PUB dependencies on FM_MATL_DTL

Line 249: FROM fm_matl_dtl

245: AND to_number(s.status_type) < to_number('1000') );
246:
247: Cursor get_fm_toq(vEntity_id NUMBER) IS
248: SELECT SUM(qty)
249: FROM fm_matl_dtl
250: WHERE formula_id = vEntity_id
251: AND line_type IN (1,2);
252:
253:

Line 277: FROM fm_matl_dtl f, mtl_system_items i

273: AND v.organization_id IS NULL;
274:
275: CURSOR Cur_experimental_items(V_form_id NUMBER) IS
276: SELECT COUNT(f.inventory_item_id)
277: FROM fm_matl_dtl f, mtl_system_items i
278: WHERE f.formula_id = V_form_id
279: AND f.inventory_item_id = i.inventory_item_id
280: AND f.organization_id = i.organization_id
281: AND i.eng_item_flag = 'Y';