eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_WH_SUPPLIER_CONS_PK dependencies on EDW_TIME_M

Line 79: FROM edw_time_m cal,

75: NVL(psp.qty_rejected_b, 0),
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

Line 203: FROM edw_time_m cal,

199: SUM(psp.qty_early_receipt_b + psp.qty_late_receipt_b +
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

Line 235: FROM edw_time_m cal,

231: -- Select the average percentage of defect
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