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 MTL_UNITS_OF_MEASURE_TL

Line 1310: ,MTL_UNITS_OF_MEASURE_TL uom_tl_s

1306: ,nvl(jsa.allocated_quantity,0))) pll_allocated
1307: --Updated to fix bug 5509464 end
1308: FROM jmf_shikyu_allocations jsa
1309: ,jmf_shikyu_replenishments jsr
1310: ,MTL_UNITS_OF_MEASURE_TL uom_tl_s
1311: --Updated to fix bug 5509464 start
1312: --WHERE jsa.replenishment_so_line_id = jsr.replenishment_so_line_id
1313: -- AND jsa.shikyu_component_id = jsr.shikyu_component_id
1314: WHERE jsa.replenishment_so_line_id(+) = jsr.replenishment_so_line_id

Line 1332: ,MTL_UNITS_OF_MEASURE_TL uom_tl

1328: ,p_item_id
1329: FROM po_headers_all pha
1330: ,po_lines_all pla
1331: ,po_line_locations_all plla
1332: ,MTL_UNITS_OF_MEASURE_TL uom_tl
1333: ,HR_ORGANIZATION_INFORMATION hoi -- Add this table to get information of oem
1334: WHERE pla.po_header_id = pha.po_header_id
1335: AND plla.po_line_id = pla.po_line_id
1336: AND pla.unit_meas_lookup_code = uom_tl.unit_of_measure

Line 1379: ,MTL_UNITS_OF_MEASURE_TL uom_tl_s

1375: ,nvl(jsa.allocated_quantity,0))) pll_allocated
1376: --Updated to fix bug 5509464 end
1377: FROM jmf_shikyu_allocations jsa
1378: ,jmf_shikyu_replenishments jsr
1379: ,MTL_UNITS_OF_MEASURE_TL uom_tl_s
1380: --Updated to fix bug 5509464 start
1381: --WHERE jsa.replenishment_so_line_id = jsr.replenishment_so_line_id
1382: -- AND jsa.shikyu_component_id = jsr.shikyu_component_id
1383: WHERE jsa.replenishment_so_line_id(+) = jsr.replenishment_so_line_id