APPS.OPI_EDW_OPM_PRD_PKG dependencies on OPI_OPM_COMMON_PKG

Line 133: BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(

129: Begin
130: IF SOURCE = 'ACTUAL' THEN
131: /* Calculate Totla Ingredient Usage Value */
132: SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
133: BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
134: BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,
135: BtchHdr.ACTUAL_CMPLT_DATE))
136: into INGREDIENT_VALUE_V
137: FROM

Line 148: BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(

144: AND BtchDtl.LINE_TYPE=-1;
145:
146: /* Calculate Item Output Value */
147: SELECT gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
148: BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
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,

Line 164: BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(

160: AND BtchDtl.LINE_NO=LINE_NO_VI;
161:
162: /*Calculate Total Batch Out Put Value */
163: SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
164: BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
165: BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,
166: DECODE(BtchHdr.BATCH_STATUS,3,BtchHdr.ACTUAL_CMPLT_DATE,
167: 4,BtchHdr.ACTUAL_CMPLT_DATE,
168: BtchHdr.EXPCT_CMPLT_DATE)))

Line 185: BtchDtl.PLAN_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(

181: INGREDIENT_VALUE_V:=INGREDIENT_VALUE_V*(l_ITEM_VALUE/L_TOTAL_BATCH_OUT_VALUE);
182: END IF;
183: ELSIF SOURCE='PLAN' THEN
184: SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
185: BtchDtl.PLAN_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
186: BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,
187: DECODE(BtchHdr.BATCH_STATUS,3,BtchHdr.ACTUAL_CMPLT_DATE,
188: 4,BtchHdr.ACTUAL_CMPLT_DATE,
189: BtchHdr.EXPCT_CMPLT_DATE)))

Line 209: BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(

205: BYPRODUCT_VALUE_V NUMBER := 0;
206: Begin
207: IF SOURCE = 'ACTUAL' THEN
208: SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
209: BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
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,

Line 222: BtchDtl.PLAN_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(

218: AND BtchDtl.ITEM_ID = ItemMst.ITEM_ID
219: AND BtchDtl.LINE_TYPE=2;
220: ELSIF SOURCE = 'PLAN' THEN
221: SELECT sum(gmicuom.i2uom_cv(BtchDtl.ITEM_ID,0,BtchDtl.ITEM_UM,
222: BtchDtl.PLAN_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
223: BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,
224: DECODE(BtchHdr.BATCH_STATUS,3,BtchHdr.ACTUAL_CMPLT_DATE,
225: 4,BtchHdr.ACTUAL_CMPLT_DATE,
226: BtchHdr.EXPCT_CMPLT_DATE)))