APPS.OPI_EDW_OPM_PRD_PKG dependencies on IC_LOTS_MST

Line 12: LOT_ID_V ic_lots_mst.lot_id%TYPE )

8: QC_GRADE_V ic_TRAN_CMP.QC_GRADE%TYPE := NULL;
9:
10: CURSOR GRADE_CHANGE_TRAN_CUR(
11: ITEM_ID_V ic_item_mst.item_id%TYPE,
12: LOT_ID_V ic_lots_mst.lot_id%TYPE )
13: IS
14: SELECT nvl(max(trans_id),0) from ic_tran_cmp_vw1
15: where item_id = item_id_v
16: and lot_id = lot_id_v