APPS.OPI_EDW_OPM_PRD_PKG dependencies on PM_MATL_DTL

Line 139: PM_MATL_DTL BtchDtl,

135: BtchHdr.ACTUAL_CMPLT_DATE))
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

Line 153: PM_MATL_DTL BtchDtl,

149: BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,BtchHdr.ACTUAL_CMPLT_DATE)
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

Line 172: PM_MATL_DTL BtchDtl,

168: BtchHdr.EXPCT_CMPLT_DATE)))
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

Line 193: PM_MATL_DTL BtchDtl,

189: BtchHdr.EXPCT_CMPLT_DATE)))
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

Line 214: PM_MATL_DTL BtchDtl,

210: BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,BtchHdr.ACTUAL_CMPLT_DATE))
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

Line 230: PM_MATL_DTL BtchDtl,

226: BtchHdr.EXPCT_CMPLT_DATE)))
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