eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PMI_SALES_PKG dependencies on PMI_SALES_PKG

Line 1: PACKAGE BODY pmi_sales_pkg as

1: PACKAGE BODY pmi_sales_pkg as
2: /* $Header: PMISAANB.pls 115.5 2003/02/19 04:47:42 srpuri ship $ */
3:
4: /* Added New function SKARIMIS 12/28/1999 */
5:

Line 33: SUM(pmi_sales_pkg.PMISA_GET_CHARGE(orderdetail.order_Id,orderdetail.line_Id,

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
36: FROM
37: OP_ORDR_HDR orderhdr,

Line 63: SUM(pmi_sales_pkg.PMISA_GET_CHARGE(orderdetail.order_Id,orderdetail.line_Id,

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
66: FROM
67: OP_ORDR_HDR orderhdr,

Line 215: pmi_sales_pkg.PMISA_GET_CHARGE(orderdetail.order_Id,orderdetail.line_Id,

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,
217: orderdetail.exchange_rate,orderdetail.mul_div_sign) line_Margin
218: FROM
219: OP_ORDR_HDR orderhdr,

Line 247: - (pmi_sales_pkg.PMIOM_GET_CHARGE(

243: fromwhse.whse_code,
244: p_cost_mthd,
245: orderdetail.Actual_Shipment_date)
246: )
247: - (pmi_sales_pkg.PMIOM_GET_CHARGE(
248: orderdetail.header_Id,
249: orderdetail.line_Id,
250: orderdetail.ordered_quantity*orderdetail.unit_selling_price,
251: orderhdr.transactional_curr_code,

Line 301: pmi_sales_pkg.PMISA_GET_CHARGE(orderdetail.order_Id,orderdetail.line_Id,

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,
303: orderdetail.exchange_rate,orderdetail.mul_div_sign) line_Margin
304: FROM
305: OP_ORDR_HDR orderhdr,

Line 333: - (pmi_sales_pkg.PMIOM_GET_CHARGE(

329: fromwhse.whse_code,
330: p_cost_mthd,
331: orderdetail.Actual_Shipment_date)
332: )
333: - (pmi_sales_pkg.PMIOM_GET_CHARGE(
334: orderdetail.header_Id,
335: orderdetail.line_Id,
336: orderdetail.ordered_quantity*orderdetail.unit_selling_price,
337: orderhdr.transactional_curr_code,

Line 688: END pmi_sales_pkg;

684: return l_total_charge;
685: END PMIOM_GET_CHARGE;
686:
687:
688: END pmi_sales_pkg;