APPS.CS_CHARGE_DETAILS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1474: mtl_system_items_b msi

1470: SELECT hou.organization_id inv_org_id
1471: FROM hr_organization_units hou,
1472: hr_organization_information hoi1,
1473: mtl_parameters mp,
1474: mtl_system_items_b msi
1475: WHERE
1476: hou.organization_id = msi.organization_id
1477: AND hou.organization_id = hoi1.organization_id
1478: AND hoi1.org_information1 = 'INV'

Line 15475: FROM mtl_system_items_b msi,

15471: IS
15472:
15473: Cursor c_primary_uom(p_inv_id IN NUMBER) IS
15474: SELECT mum.uom_code
15475: FROM mtl_system_items_b msi,
15476: MTL_UNITS_OF_MEASURE_TL mum
15477: WHERE msi.PRIMARY_UNIT_OF_MEASURE = mum.unit_of_measure
15478: AND msi.INVENTORY_ITEM_ID = P_INV_ID
15479: AND msi.organization_id = cs_std.get_item_valdn_orgzn_id;