APPS.POA_WH_SUPPLIER_CONS_PK dependencies on EDW_ITEMS_M

Line 80: edw_items_m item,

76: NVL((psp.qty_late_receipt_b + psp.qty_early_receipt_b +
77: psp.qty_past_due_b), 0),
78: psp.date_dim_fk_key
79: FROM edw_time_m cal,
80: edw_items_m item,
81: edw_trd_partner_m tp,
82: poa_edw_sup_perf_f psp
83: WHERE psp.item_fk_key = item.irev_item_revision_pk_key
84: AND item.item_item_name = p_item_name

Line 204: edw_items_m item,

200: psp.qty_past_due_b) / SUM(psp.qty_ordered_b - psp.qty_cancelled_b)
201: INTO v_pref_purch_price,
202: v_pref_pct_del_excp
203: FROM edw_time_m cal,
204: edw_items_m item,
205: edw_trd_partner_m tp,
206: poa_edw_sup_perf_f psp
207: WHERE psp.item_fk_key = item.irev_item_revision_pk_key
208: AND item.item_item_name = p_item_name

Line 236: edw_items_m item,

232:
233: SELECT SUM(psp.qty_rejected_b)/SUM(psp.qty_received_b)
234: INTO v_pref_pct_defect
235: FROM edw_time_m cal,
236: edw_items_m item,
237: edw_trd_partner_m tp,
238: poa_edw_sup_perf_f psp
239: WHERE psp.item_fk_key = item.irev_item_revision_pk_key
240: AND item.item_item_name = p_item_name