566:
567: BEGIN
568: SELECT fc.extended_precision, gsob.currency_code
569: INTO gn_precision_val, gc_currency_code
570: FROM gl_sets_of_books gsob,
571: org_organization_definitions ood,
572: fnd_currencies fc
573: WHERE ood.organization_id = p_inventory_org
574: AND ood.set_of_books_id = gsob.set_of_books_id
2714: ,OOD.organization_name
2715: ,GSOB.currency_code ';
2716:
2717: v_from_clause := ' FROM mtl_system_items_b MSI
2718: ,gl_sets_of_books GSOB
2719: ,org_organization_definitions OOD
2720: ,mtl_material_transactions MTX ';
2721:
2722: v_where_clause := ' WHERE MSI.organization_id = ' || p_org_id ||