DBA Data[Home] [Help]

APPS.POA_WH_SUPPLIER_CONS_PK dependencies on POA_EDW_SUP_PERF_F

Line 82: poa_edw_sup_perf_f psp

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
85: AND psp.date_dim_fk_key = cal.cday_cal_day_pk_key
86: AND psp.supplier_site_fk_key = tp.tplo_tpartner_loc_pk_key

Line 206: poa_edw_sup_perf_f psp

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
209: AND psp.date_dim_fk_key = cal.cday_cal_day_pk_key
210: AND psp.supplier_site_fk_key = tp.tplo_tpartner_loc_pk_key

Line 238: poa_edw_sup_perf_f psp

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
241: AND psp.date_dim_fk_key = cal.cday_cal_day_pk_key
242: AND psp.supplier_site_fk_key = tp.tplo_tpartner_loc_pk_key