DBA Data[Home] [Help]

APPS.GR_PROCESS_DOCUMENTS dependencies on GR_EMEA

Line 292: FROM gr_emea em,

288: em.consolidated_risk_phrase,
289: em.consolidated_safety_phrase,
290: fnu.user_name,
291: pc.product_class_desc
292: FROM gr_emea em,
293: gr_product_classes pc,
294: fnd_user fnu,
295: gr_item_general ig1
296: WHERE ig1.item_code >= g_start_item

Line 315: FROM gr_emea em,

311: ig1.item_group_code,
312: em.eec_number,
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 (+)