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.GME_TRANSACTIONS_PVT dependencies on INV_CONVERT

Line 1710: l_prim_qty := inv_convert.inv_um_convert

1706: IF (l_mmli_tbl(i).primary_quantity IS NULL) THEN
1707: l_prim_qty := l_mmli_tbl(i).transaction_quantity;
1708: IF (l_primary_uom <> x_mmti_rec.transaction_uom) THEN
1709:
1710: l_prim_qty := inv_convert.inv_um_convert
1711: (item_id => x_mmti_rec.inventory_item_id
1712: ,lot_number => l_mmli_tbl(i).lot_number
1713: ,organization_id => x_mmti_rec.organization_id
1714: ,precision => gme_common_pvt.g_precision

Line 1723: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');

1719: ,to_name => NULL);
1720:
1721: IF l_prim_qty = -99999 THEN
1722: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1723: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');
1724: END IF;
1725: RAISE um_convert_error;
1726: END IF;
1727:

Line 1729: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');

1725: RAISE um_convert_error;
1726: END IF;
1727:
1728: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1729: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');
1730: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_prim_qty= '||to_char(l_prim_qty));
1731: END IF;
1732: END IF;
1733: l_mmli_tbl(i).primary_quantity := l_prim_qty;

Line 1741: l_secondary_qty := inv_convert.inv_um_convert

1737: IF (l_mmli_tbl(i).secondary_transaction_quantity IS NULL AND l_secondary_uom IS NOT NULL) THEN
1738: l_secondary_qty := l_mmli_tbl(i).transaction_quantity;
1739: IF (l_secondary_uom <> x_mmti_rec.transaction_uom) THEN
1740:
1741: l_secondary_qty := inv_convert.inv_um_convert
1742: (item_id => x_mmti_rec.inventory_item_id
1743: ,lot_number => l_mmli_tbl(i).lot_number
1744: ,organization_id => x_mmti_rec.organization_id
1745: ,precision => gme_common_pvt.g_precision

Line 1754: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');

1750: ,to_name => NULL);
1751:
1752: IF l_secondary_qty = -99999 THEN
1753: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1754: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');
1755: END IF;
1756: RAISE um_convert_error;
1757: END IF;
1758:

Line 1760: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');

1756: RAISE um_convert_error;
1757: END IF;
1758:
1759: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1760: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');
1761: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_secondary_qty= '||to_char(l_secondary_qty));
1762: END IF;
1763: END IF;
1764: l_mmli_tbl(i).secondary_transaction_quantity := l_secondary_qty;

Line 3221: inv_convert.inv_um_convert (d.inventory_item_id,

3217: v_trans_uom IN VARCHAR2
3218: ) IS
3219: SELECT SUM (DECODE (v_trans_uom,
3220: t.transaction_uom, transaction_quantity,
3221: inv_convert.inv_um_convert (d.inventory_item_id,
3222: gme_common_pvt.g_precision,
3223: t.transaction_quantity,
3224: t.transaction_uom,
3225: v_trans_uom,

Line 3253: inv_convert.inv_um_convert (d.inventory_item_id,

3249: ) IS
3250: SELECT lot_number,
3251: SUM (DECODE (v_trans_uom,
3252: m.transaction_uom, m.transaction_quantity,
3253: inv_convert.inv_um_convert (d.inventory_item_id,
3254: v_lot_number,
3255: v_organization_id,
3256: gme_common_pvt.g_precision,
3257: m.transaction_quantity,

Line 3822: Inv_Convert.inv_um_convert(d.inventory_item_id,tl.lot_number,t.organization_id, 5

3818: ,v_mat_det_id IN NUMBER) IS
3819: SELECT a.transaction_id, a.lot_number, a.doc_qty, SUM(a.doc_qty) over() mtl_qty
3820: FROM (SELECT t.transaction_id, tl.lot_number,
3821: DECODE(d.dtl_um,t.transaction_uom, NVL(tl.transaction_quantity,t.transaction_quantity),
3822: Inv_Convert.inv_um_convert(d.inventory_item_id,tl.lot_number,t.organization_id, 5
3823: ,NVL(tl.transaction_quantity,t.transaction_quantity), t.transaction_uom
3824: ,d.dtl_um, NULL, NULL)) doc_qty
3825: FROM mtl_material_transactions t , gme_material_details d, mtl_transaction_lot_numbers tl
3826: WHERE t.organization_id = v_organization_id