DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_ITEM_REVISIONS

Line 440: FROM mtl_item_revisions

436: ELSE
437: BEGIN
438: SELECT 1
439: INTO l_dummy
440: FROM mtl_item_revisions
441: WHERE inventory_item_id = p_inv_item_id
442: AND organization_id = p_inv_org_id
443: AND revision = p_revision;
444: l_return_value := TRUE;

Line 461: FROM mtl_item_revisions

457: IF ((p_revision IS NOT NULL) AND (p_revision <> FND_API.G_MISS_CHAR)) THEN
458: BEGIN
459: SELECT 1
460: INTO l_dummy
461: FROM mtl_item_revisions
462: WHERE inventory_item_id = p_inv_item_id
463: AND organization_id = p_inv_org_id
464: AND revision = p_revision;
465: l_return_value := TRUE;

Line 541: FROM mtl_item_revisions

537: ELSE
538: BEGIN
539: SELECT 1
540: INTO l_dummy
541: FROM mtl_item_revisions
542: WHERE inventory_item_id = p_inv_item_id
543: AND organization_id = p_inv_org_id
544: AND revision = p_revision;
545: l_return_value := TRUE;

Line 562: FROM mtl_item_revisions

558: IF ((p_revision IS NOT NULL) AND (p_revision <> FND_API.G_MISS_CHAR)) THEN
559: BEGIN
560: SELECT 1
561: INTO l_dummy
562: FROM mtl_item_revisions
563: WHERE inventory_item_id = p_inv_item_id
564: AND organization_id = p_inv_org_id
565: AND revision = p_revision;
566: l_return_value := TRUE;