DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_CUR_PVT dependencies on JMF_SHIKYU_RPT_UTIL

Line 243: ,jmf_shikyu_rpt_util.get_item_number(l.org_id

239: ,pv.vendor_site_code
240: ,h.segment1
241: ,l.line_num
242: ,sub.osa_item_id
243: ,jmf_shikyu_rpt_util.get_item_number(l.org_id
244: ,l.item_id)
245: ,mtl.description
246: ,sub.osa_item_price
247: ,sub.currency

Line 258: ,decode(sub.currency,lp_func_currency_code,sub.osa_item_price,jmf_shikyu_rpt_util.convert_amount(sub.currency

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
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))

Line 594: ,jmf_shikyu_rpt_util.get_item_number(sol.org_id

590: ,tasks.task_number
591: ,soh.order_number
592: ,sol.line_number
593: ,sol.inventory_item_id
594: ,jmf_shikyu_rpt_util.get_item_number(sol.org_id
595: ,sol.inventory_item_id) item_num
596: ,mtl.description
597: ,sol.unit_selling_price
598: ,soh.transactional_curr_code

Line 612: , sol.unit_selling_price,jmf_shikyu_rpt_util.convert_amount(soh.transactional_curr_code

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
613: ,lp_func_currency_code
614: /* ,lp_currency_cnv_date
615: ,lp_currency_cnv_type*/
616: ,decode(lp_currency_cnv_date,null,sysdate,lp_currency_cnv_date)

Line 1049: ,jmf_shikyu_rpt_util.get_item_number(sol.org_id

1045: ,tasks.task_number
1046: ,soh.order_number
1047: ,sol.line_number
1048: ,sol.inventory_item_id
1049: ,jmf_shikyu_rpt_util.get_item_number(sol.org_id
1050: ,sol.inventory_item_id) item_num
1051: ,mtl.description
1052: ,sol.shipped_quantity
1053: ,sol.flow_status_code