DBA Data[Home] [Help]

APPS.PMI_SALES_PKG dependencies on PMI_COMMON_PKG

Line 31: pmi_common_pkg.PMICO_GET_COST(orderdetail.item_id,

27: Decode(orderdetail.mul_div_sign,0,orderdetail.EXTENDED_PRICE*orderdetail.EXCHANGE_RATE,
28: orderdetail.EXTENDED_PRICE/orderdetail.EXCHANGE_RATE)))-
29: SUM(gmicuom.I2UOM_CV(orderdetail.Item_Id,0,orderdetail.ORDER_UM1,
30: orderdetail.ORDER_QTY1,itemmst.Item_UM)*
31: pmi_common_pkg.PMICO_GET_COST(orderdetail.item_id,
32: orderdetail.From_whse,p_cost_mthd,orderdetail.Actual_Shipdate))-
33: SUM(pmi_sales_pkg.PMISA_GET_CHARGE(orderdetail.order_Id,orderdetail.line_Id,
34: orderdetail.extended_price,orderdetail.billing_currency,orderdetail.base_currency,
35: orderdetail.exchange_rate,orderdetail.mul_div_sign)) Margin

Line 61: pmi_common_pkg.PMICO_GET_COST(orderdetail.item_id,

57: Decode(orderdetail.mul_div_sign,0,orderdetail.EXTENDED_PRICE*orderdetail.EXCHANGE_RATE,
58: orderdetail.EXTENDED_PRICE/orderdetail.EXCHANGE_RATE)))-
59: SUM(gmicuom.I2UOM_CV(orderdetail.Item_Id,0,orderdetail.ORDER_UM1,
60: orderdetail.ORDER_QTY1,itemmst.Item_UM)*
61: pmi_common_pkg.PMICO_GET_COST(orderdetail.item_id,
62: orderdetail.From_whse,p_cost_mthd,orderdetail.Actual_Shipdate))-
63: SUM(pmi_sales_pkg.PMISA_GET_CHARGE(orderdetail.order_Id,orderdetail.line_Id,
64: orderdetail.extended_price,orderdetail.billing_currency,orderdetail.base_currency,
65: orderdetail.exchange_rate,orderdetail.mul_div_sign)) Margin

Line 212: pmi_common_pkg.PMICO_GET_COST(orderdetail.item_id,

208: orderdetail.EXTENDED_PRICE/orderdetail.EXCHANGE_RATE))
209: -
210: gmicuom.I2UOM_CV(orderdetail.Item_Id,0,orderdetail.ORDER_UM1,
211: orderdetail.ORDER_QTY1,itemmst.Item_UM)*
212: pmi_common_pkg.PMICO_GET_COST(orderdetail.item_id,
213: orderdetail.From_whse,p_cost_mthd,orderdetail.Actual_Shipdate)
214: -
215: pmi_sales_pkg.PMISA_GET_CHARGE(orderdetail.order_Id,orderdetail.line_Id,
216: orderdetail.extended_price,orderdetail.billing_currency,orderdetail.base_currency,

Line 242: pmi_common_pkg.PMICO_GET_COST(itemmst.item_id,

238: )
239: - (gmicuom.I2UOM_CV(itemmst.Item_Id,
240: 0, orderdetail.ORDER_QUANTITY_UOM,
241: orderdetail.ORDERED_QUANTITY,itemmst.Item_UM)*
242: pmi_common_pkg.PMICO_GET_COST(itemmst.item_id,
243: fromwhse.whse_code,
244: p_cost_mthd,
245: orderdetail.Actual_Shipment_date)
246: )

Line 298: pmi_common_pkg.PMICO_GET_COST(orderdetail.item_id,

294: orderdetail.EXTENDED_PRICE/orderdetail.EXCHANGE_RATE))
295: -
296: gmicuom.I2UOM_CV(orderdetail.Item_Id,0,orderdetail.ORDER_UM1,
297: orderdetail.ORDER_QTY1,itemmst.Item_UM)*
298: pmi_common_pkg.PMICO_GET_COST(orderdetail.item_id,
299: orderdetail.From_whse,p_cost_mthd,orderdetail.Actual_Shipdate)
300: -
301: pmi_sales_pkg.PMISA_GET_CHARGE(orderdetail.order_Id,orderdetail.line_Id,
302: orderdetail.extended_price,orderdetail.billing_currency,orderdetail.base_currency,

Line 328: pmi_common_pkg.PMICO_GET_COST(itemmst.item_id,

324: )
325: - (gmicuom.I2UOM_CV(itemmst.Item_Id,
326: 0, orderdetail.ORDER_QUANTITY_UOM,
327: orderdetail.ORDERED_QUANTITY,itemmst.Item_UM)*
328: pmi_common_pkg.PMICO_GET_COST(itemmst.item_id,
329: fromwhse.whse_code,
330: p_cost_mthd,
331: orderdetail.Actual_Shipment_date)
332: )