DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_LINES_PUB dependencies on MTL_ITEM_UOMS_VIEW

Line 225: FROM mtl_item_uoms_view

221: AND l_pvt_RQL_Tbl(I).uom_code <> FND_API.G_MISS_CHAR) THEN
222: BEGIN
223: SELECT count(uom_code)
224: INTO l_count
225: FROM mtl_item_uoms_view
226: WHERE inventory_item_id = l_pvt_RQL_Tbl(I).inventory_item_id
227: AND organization_id =
228: decode(nvl(l_pvt_RQL_Tbl(I).source_organization_id, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, organization_id, l_pvt_RQL_Tbl(I).source_organization_id)
229: AND uom_code = l_pvt_RQL_Tbl(I).uom_code;