APPS.PMI_LOT_GENEALOGY_PKG dependencies on IC_TRAN_VW1

Line 73: FROM ic_tran_vw1

69: lv_date := TO_DATE(fnd_profile.value('PMI$LOTGEN_REFRESH_DATE'), datetime_format);
70: EXCEPTION
71: WHEN OTHERS THEN
72: SELECT MIN(trans_date) into lv_date
73: FROM ic_tran_vw1
74: WHERE doc_type = 'PROD'
75: AND completed_ind = 1
76: AND lot_id <> 0;
77: END; RETURN lv_date;