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_CFR_PVT dependencies on PO_UOM_S

Line 1322: AND po_uom_s.get_primary_uom(pla.item_id,p_tp_inv_org_id,null) = uom_tl_s.unit_of_measure -- primary UOM

1318: AND plla.po_line_id = pla.po_line_id
1319: AND uom_tl_s.LANGUAGE = USERENV('LANG')
1320: -- fix bug 5702139
1321: -- AND pla.unit_meas_lookup_code = uom_tl_s.unit_of_measure
1322: AND po_uom_s.get_primary_uom(pla.item_id,p_tp_inv_org_id,null) = uom_tl_s.unit_of_measure -- primary UOM
1323: AND jsr.shikyu_component_id = p_item_id) residual_unallocated_pri
1324: ,pha.vendor_id --p_supplier_id
1325: ,pha.vendor_site_id --p_supplier_site_id
1326: ,p_oem_inv_org_id

Line 1390: AND po_uom_s.get_primary_uom(pla.item_id,p_tp_inv_org_id,null) = uom_tl_s.unit_of_measure -- primary UOM

1386: AND jsr.replenishment_po_shipment_id = plla.line_location_id
1387: AND plla.po_line_id = pla.po_line_id
1388: -- fix bug 5702139
1389: -- AND pla.unit_meas_lookup_code = uom_tl_s.unit_of_measure
1390: AND po_uom_s.get_primary_uom(pla.item_id,p_tp_inv_org_id,null) = uom_tl_s.unit_of_measure -- primary UOM
1391: AND jsr.shikyu_component_id = p_item_id);
1392:
1393: --update the residual_unallocated(quantity) column under UOM.
1394: UPDATE jmf_shikyu_cfr_mid_temp

Line 3211: PO_UOM_S.po_uom_convert_p(cfr_mid.primary_uom

3207: ,decode(p_currency_conversion_type,null,ooha.CONVERSION_TYPE_CODE,p_currency_conversion_type)
3208: --Amy update for fixing currency conversing issue end
3209: ,NVL(cic.item_cost
3210: ,0) *
3211: PO_UOM_S.po_uom_convert_p(cfr_mid.primary_uom
3212: ,cfr_mid.uom
3213: ,cfr_mid.item_id)) item_cost --the cost based on UOM after conversion from Pri_Uom
3214: ,(cfr_mid.quantity *
3215: PO_UOM_S.po_uom_convert_p(cfr_mid.uom

Line 3215: PO_UOM_S.po_uom_convert_p(cfr_mid.uom

3211: PO_UOM_S.po_uom_convert_p(cfr_mid.primary_uom
3212: ,cfr_mid.uom
3213: ,cfr_mid.item_id)) item_cost --the cost based on UOM after conversion from Pri_Uom
3214: ,(cfr_mid.quantity *
3215: PO_UOM_S.po_uom_convert_p(cfr_mid.uom
3216: ,cfr_mid.primary_uom
3217: ,cfr_mid.item_id)) value1 --item qty in Primary
3218: ,JMF_SHIKYU_RPT_UTIL.convert_amount(ooha.transactional_curr_code
3219: ,p_functional_currency

Line 3229: PO_UOM_S.po_uom_convert_p(cfr_mid.uom

3225: ,decode(p_currency_conversion_date,null,sysdate,p_currency_conversion_date)
3226: ,decode(p_currency_conversion_type,null,ooha.CONVERSION_TYPE_CODE,p_currency_conversion_type)
3227: --Amy update for fixing currency conversing issue end
3228: ,oola.unit_selling_price *
3229: PO_UOM_S.po_uom_convert_p(cfr_mid.uom
3230: ,cfr_mid.primary_uom
3231: ,cfr_mid.item_id)) value2 --the item price in Pri UOM and Pri Currency
3232: ,NVL(cic.item_cost
3233: ,0) value3 --Standard_Item_Cost in Pri UOM and Pri Currency

Line 3571: SET jscrt.estimated_qty = PO_UOM_S.po_uom_convert_p(jscrt.primary_uom

3567: */
3568:
3569: -- Deleted Update to fix bug 5665445 for incorrect onhand Qty in Secondary UOM case
3570: /* UPDATE JMF_SHIKYU_CFR_RPT_TEMP jscrt
3571: SET jscrt.estimated_qty = PO_UOM_S.po_uom_convert_p(jscrt.primary_uom
3572: ,jscrt.uom
3573: ,jscrt.item_id) *jscrt.ESTIMATED_QTY,
3574: (SELECT jscmt.primary_unconsumed_quantity
3575: FROM jmf_shikyu_cfr_mid_temp jscmt

Line 4423: SET jscrt.estimated_qty = PO_UOM_S.po_uom_convert_p(jscrt.primary_uom

4419: */
4420:
4421: -- Deleted Update to fix bug 5665445 for incorrect onhand Qty in Secondary UOM case
4422: /* UPDATE JMF_SHIKYU_CFR_RPT_TEMP jscrt
4423: SET jscrt.estimated_qty = PO_UOM_S.po_uom_convert_p(jscrt.primary_uom
4424: ,jscrt.uom
4425: ,jscrt.item_id) *jscrt.ESTIMATED_QTY,
4426: (SELECT jscmt.primary_unconsumed_quantity
4427: FROM jmf_shikyu_cfr_mid_temp jscmt