DBA Data[Home] [Help]

APPS.PMI_PRODUCTION_SUM dependencies on IC_LOTS_MST

Line 267: LOT_ID_V ic_lots_mst.lot_id%TYPE )

263: QC_GRADE_V ic_TRAN_CMP.QC_GRADE%TYPE := NULL;
264:
265: CURSOR GRADE_CHANGE_TRAN_CUR(
266: ITEM_ID_V ic_item_mst.item_id%TYPE,
267: LOT_ID_V ic_lots_mst.lot_id%TYPE )
268: IS
269: SELECT nvl(max(trans_id),0) from ic_tran_cmp_vw1
270: where item_id = item_id_v
271: and lot_id = lot_id_v