DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_LINES_PUB dependencies on MTL_ITEM_REVISIONS

Line 245: FROM mtl_item_revisions

241: AND l_pvt_RQL_Tbl(I).revision <> FND_API.G_MISS_CHAR) THEN
242: BEGIN
243: SELECT count(revision)
244: INTO l_count
245: FROM mtl_item_revisions
246: WHERE inventory_item_id = l_pvt_RQL_Tbl(I).inventory_item_id
247: AND organization_id =
248: 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)
249: AND revision = l_pvt_RQL_Tbl(I).revision;