APPS.GR_PROCESS_DOCUMENTS dependencies on GR_ITEM_CONCENTRATIONS

Line 222: FROM gr_item_concentrations ic

218: */
219: CURSOR g_get_explosion_count
220: IS
221: SELECT COUNT(*) count
222: FROM gr_item_concentrations ic
223: WHERE ic.item_code = g_current_item;
224: /*
225: ** Get the document work structure
226: */

Line 317: gr_item_concentrations ic

313: em.consolidated_risk_phrase,
314: em.consolidated_safety_phrase
315: FROM gr_emea em,
316: gr_item_general ig1,
317: gr_item_concentrations ic
318: WHERE ic.item_code = GlobalItemRecord.item_code
319: AND ic.ingredient_item_code = em.item_code (+)
320: AND ic.ingredient_item_code = ig1.item_code
321: ORDER BY 2 desc;