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.JMF_SHIKYU_RPT_CUR_PVT dependencies on JMF_SHIKYU_RPT_CUR_PVT

Line 1: PACKAGE BODY jmf_shikyu_rpt_cur_pvt AS

1: PACKAGE BODY jmf_shikyu_rpt_cur_pvt AS
2: --$Header: JMFVCURB.pls 120.25 2008/03/22 06:21:14 kdevadas ship $
3: --+===========================================================================+
4: --| Copyright (c) 2005 Oracle Corporation |
5: --| Redwood Shores, California, USA |

Line 85: g_pkg_name CONSTANT VARCHAR2(30) := 'JMF_SHIKYU_RPT_CUR_PVT';

81:
82: --=============================================
83: -- CONSTANTS
84: --=============================================
85: g_pkg_name CONSTANT VARCHAR2(30) := 'JMF_SHIKYU_RPT_CUR_PVT';
86: g_module_prefix CONSTANT VARCHAR2(50) := 'jmf.plsql.' || g_pkg_name || '.';
87:
88: --=============================================
89: -- GLOBAL VARIABLES

Line 250: -- ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.org_id

246: ,sub.osa_item_price
247: ,sub.currency
248: ,loc.quantity - loc.quantity_received unreceived_qty
249: ,l.unit_meas_lookup_code
250: -- ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.org_id
251: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.ship_to_organization_id
252: ,sub.osa_item_id
253: ,1) frozend_cost
254: -- ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.org_id

Line 251: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.ship_to_organization_id

247: ,sub.currency
248: ,loc.quantity - loc.quantity_received unreceived_qty
249: ,l.unit_meas_lookup_code
250: -- ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.org_id
251: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.ship_to_organization_id
252: ,sub.osa_item_id
253: ,1) frozend_cost
254: -- ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.org_id
255: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.ship_to_organization_id

Line 254: -- ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.org_id

250: -- ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.org_id
251: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.ship_to_organization_id
252: ,sub.osa_item_id
253: ,1) frozend_cost
254: -- ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.org_id
255: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.ship_to_organization_id
256: ,sub.osa_item_id
257: ,lp_cost_type_id)
258: ,decode(sub.currency,lp_func_currency_code,sub.osa_item_price,jmf_shikyu_rpt_util.convert_amount(sub.currency

Line 255: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.ship_to_organization_id

251: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.ship_to_organization_id
252: ,sub.osa_item_id
253: ,1) frozend_cost
254: -- ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.org_id
255: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(loc.ship_to_organization_id
256: ,sub.osa_item_id
257: ,lp_cost_type_id)
258: ,decode(sub.currency,lp_func_currency_code,sub.osa_item_price,jmf_shikyu_rpt_util.convert_amount(sub.currency
259: ,lp_func_currency_code

Line 263: ,jmf_shikyu_rpt_cur_pvt.get_uom_primary_qty(l.item_id

259: ,lp_func_currency_code
260: ,decode(lp_currency_cnv_date,null,sysdate,lp_currency_cnv_date)
261: ,decode(lp_currency_cnv_type,null,h.rate_type,lp_currency_cnv_type)
262: ,sub.osa_item_price))
263: ,jmf_shikyu_rpt_cur_pvt.get_uom_primary_qty(l.item_id
264: ,loc.ship_to_organization_id
265: ,2
266: ,1
267: -- ,loc.unit_meas_lookup_code)

Line 605: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(sol.ship_from_org_id

601: -- ,sol.ordered_quantity - nvl(sol.shipped_quantity,0) unshipped_qty
602: ,repo.allocated_quantity unshipped_quantity
603: -- Updated to fix bug 5462851 end
604: ,sol.pricing_quantity_uom
605: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(sol.ship_from_org_id
606: ,sol.inventory_item_id
607: ,1) frozend_cost
608: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(sol.ship_from_org_id
609: ,sol.inventory_item_id

Line 608: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(sol.ship_from_org_id

604: ,sol.pricing_quantity_uom
605: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(sol.ship_from_org_id
606: ,sol.inventory_item_id
607: ,1) frozend_cost
608: ,jmf_shikyu_rpt_cur_pvt.cuar_get_item_cost(sol.ship_from_org_id
609: ,sol.inventory_item_id
610: ,lp_cost_type_id) planned_cost
611: ,decode(soh.transactional_curr_code,lp_func_currency_code
612: , sol.unit_selling_price,jmf_shikyu_rpt_util.convert_amount(soh.transactional_curr_code

Line 619: ,jmf_shikyu_rpt_cur_pvt.get_uom_primary_qty_from_code(sol.inventory_item_id

615: ,lp_currency_cnv_type*/
616: ,decode(lp_currency_cnv_date,null,sysdate,lp_currency_cnv_date)
617: ,decode(lp_currency_cnv_type,null,soh.CONVERSION_TYPE_CODE,lp_currency_cnv_type)
618: ,sol.unit_selling_price)) convert_amount
619: ,jmf_shikyu_rpt_cur_pvt.get_uom_primary_qty_from_code(sol.inventory_item_id
620: ,sol.ship_from_org_id
621: ,2
622: ,1
623: ,sol.pricing_quantity_uom) exchange_UOM-- returns qty in primary UOM for 1 UOM in document

Line 1565: END jmf_shikyu_rpt_cur_pvt;

1561: END IF;
1562:
1563: END get_uom_primary_qty_from_code;
1564:
1565: END jmf_shikyu_rpt_cur_pvt;