DBA Data[Home] [Help]

APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on MTL_UNITS_OF_MEASURE_TL

Line 1623: FROM mtl_units_of_measure_tl uom

1619: --The following code is added by Yao Zhang for bug 8339490
1620: BEGIN
1621: SELECT uom.unit_of_measure_tl
1622: INTO l_uom_name
1623: FROM mtl_units_of_measure_tl uom
1624: WHERE uom.uom_code = l_invoice_line.uom
1625: AND uom.LANGUAGE = userenv('LANG');
1626: EXCEPTION
1627: WHEN no_data_found THEN

Line 4792: ,mtl_units_of_measure_tl muom --yao zhang add for bug 8339490

4788: mtl_system_items_b_kfv items
4789: ,mtl_item_categories mic
4790: ,mtl_category_sets_b mcs
4791: ,mtl_categories_b_kfv mc
4792: ,mtl_units_of_measure_tl muom --yao zhang add for bug 8339490
4793: WHERE items.organization_id=l_master_org_id
4794: AND items.inventory_item_status_code=nvl(l_item_status,items.inventory_item_status_code)
4795: AND items.concatenated_segments>=nvl(l_item_num_from,items.concatenated_segments)
4796: AND items.concatenated_segments<=nvl(l_item_num_to,items.concatenated_segments)