DBA Data[Home] [Help]

APPS.OZF_CLAIM_PUB dependencies on MTL_UNITS_OF_MEASURE

Line 78: FROM mtl_units_of_measure a,

74:
75: -- Fix for Bug 11932210
76: CURSOR c_item_uom(p_item_uom IN VARCHAR2,p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS
77: SELECT a.uom_code
78: FROM mtl_units_of_measure a,
79: mtl_system_items c
80: WHERE c.primary_unit_of_measure = a.unit_of_measure
81: AND c.organization_id = p_org_id
82: AND c.inventory_item_id = p_inventory_item_id

Line 682: FROM mtl_units_of_measure a,

678:
679: -- Fix for Bug 11932210
680: CURSOR c_item_uom(p_item_uom IN VARCHAR2,p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS
681: SELECT a.uom_code
682: FROM mtl_units_of_measure a,
683: mtl_system_items c
684: WHERE c.primary_unit_of_measure = a.unit_of_measure
685: AND c.organization_id = p_org_id
686: AND c.inventory_item_id = p_inventory_item_id