DBA Data[Home] [Help]

APPS.EDW_ITEMS_M_SIZE dependencies on PO_LINES_ALL

Line 212: po_lines_all l,

208: avg(nvl(vsize(NULL), 0)) +
209: 47
210: From
211: mtl_categories_kfv cat,
212: po_lines_all l,
213: edw_local_instance inst
214: WHERE cat.category_id = l.category_id
215: and l.item_id is null
216: and l.last_update_date between

Line 249: po_lines_all l

245: avg(nvl(vsize(NULL), 0)) +
246: 17
247: From edw_local_instance inst,
248: mtl_categories_kfv cat,
249: po_lines_all l
250: WHERE cat.category_id = l.category_id
251: and l.item_id is null
252: and l.last_update_date between
253: p_from_date and p_to_date