DBA Data[Home] [Help]

APPS.GME_TRANSACTIONS_PVT dependencies on INV_CONVERT

Line 2373: inv_convert.inv_um_convert (d.inventory_item_id,

2369: v_trans_uom IN VARCHAR2
2370: ) IS
2371: SELECT SUM (DECODE (v_trans_uom,
2372: t.transaction_uom, transaction_quantity,
2373: inv_convert.inv_um_convert (d.inventory_item_id,
2374: gme_common_pvt.g_precision,
2375: t.transaction_quantity,
2376: t.transaction_uom,
2377: v_trans_uom,

Line 2405: inv_convert.inv_um_convert (d.inventory_item_id,

2401: ) IS
2402: SELECT lot_number,
2403: SUM (DECODE (v_trans_uom,
2404: m.transaction_uom, m.transaction_quantity,
2405: inv_convert.inv_um_convert (d.inventory_item_id,
2406: gme_common_pvt.g_precision,
2407: m.transaction_quantity,
2408: m.transaction_uom,
2409: v_trans_uom,

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

2959: ,v_mat_det_id IN NUMBER) IS
2960: SELECT a.transaction_id, a.lot_number, a.doc_qty, SUM(a.doc_qty) over() mtl_qty
2961: FROM (SELECT t.transaction_id, tl.lot_number,
2962: DECODE(d.dtl_um,t.transaction_uom, NVL(tl.transaction_quantity,t.transaction_quantity),
2963: Inv_Convert.inv_um_convert(d.inventory_item_id,tl.lot_number,t.organization_id, 5
2964: ,NVL(tl.transaction_quantity,t.transaction_quantity), t.transaction_uom
2965: ,d.dtl_um, NULL, NULL)) doc_qty
2966: FROM mtl_material_transactions t , gme_material_details d, mtl_transaction_lot_numbers tl
2967: WHERE t.organization_id = v_organization_id