APPS.OPI_EDW_OPM_PRD_PKG dependencies on IC_ITEM_MST

Line 11: ITEM_ID_V ic_item_mst.item_id%TYPE,

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

Line 140: IC_ITEM_MST ItemMst

136: into INGREDIENT_VALUE_V
137: FROM
138: PM_BTCH_HDR BtchHdr,
139: PM_MATL_DTL BtchDtl,
140: IC_ITEM_MST ItemMst
141: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
142: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
143: AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID
144: AND BtchDtl.LINE_TYPE=-1;

Line 154: IC_ITEM_MST ItemMst

150: into L_ITEM_VALUE
151: FROM
152: PM_BTCH_HDR BtchHdr,
153: PM_MATL_DTL BtchDtl,
154: IC_ITEM_MST ItemMst
155: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
156: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
157: AND BtchDtl.ITEM_ID = Itemmst.ITEM_ID
158: AND BtchDtl.LINE_TYPE=1

Line 173: IC_ITEM_MST ItemMst

169: into L_TOTAL_BATCH_OUT_VALUE
170: FROM
171: PM_BTCH_HDR BtchHdr,
172: PM_MATL_DTL BtchDtl,
173: IC_ITEM_MST ItemMst
174: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
175: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
176: AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID
177: AND BtchDtl.LINE_TYPE=1;

Line 194: IC_ITEM_MST ItemMst

190: into INGREDIENT_VALUE_V
191: FROM
192: PM_BTCH_HDR BtchHdr,
193: PM_MATL_DTL BtchDtl,
194: IC_ITEM_MST ItemMst
195: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
196: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
197: AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID
198: AND BtchDtl.LINE_TYPE=-1;

Line 215: IC_ITEM_MST ItemMst

211: into BYPRODUCT_VALUE_V
212: FROM
213: PM_BTCH_HDR BtchHdr,
214: PM_MATL_DTL BtchDtl,
215: IC_ITEM_MST ItemMst
216: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
217: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
218: AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID
219: AND BtchDtl.LINE_TYPE=2;

Line 231: IC_ITEM_MST ItemMst

227: into BYPRODUCT_VALUE_V
228: FROM
229: PM_BTCH_HDR BtchHdr,
230: PM_MATL_DTL BtchDtl,
231: IC_ITEM_MST ItemMst
232: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
233: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID
234: AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID
235: AND BtchDtl.LINE_TYPE=2;