APPS.PMI_PRODUCTION_SUM dependencies on IC_ITEM_MST

Line 266: ITEM_ID_V ic_item_mst.item_id%TYPE,

262: TRANS_ID_V ic_TRAN_CMP.TRANS_id%TYPE := NULL;
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

Line 563: IC_ITEM_MST ItemMst

559: into PLAN_ING_VALUE_V
560: FROM
561: GME_BATCH_HEADER BtchHdr,
562: GME_MATERIAL_DETAILS BtchDtl,
563: IC_ITEM_MST ItemMst
564: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
565: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
566: AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID
567: AND BtchDtl.LINE_TYPE=-1;

Line 583: IC_ITEM_MST ItemMst

579: into ACTUAL_ING_VALUE_V
580: FROM
581: GME_BATCH_HEADER BtchHdr,
582: GME_MATERIAL_DETAILS BtchDtl,
583: IC_ITEM_MST ItemMst
584: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
585: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
586: AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID
587: AND BtchDtl.LINE_TYPE=-1;