DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_ITEM_REVISIONS

Line 441: FROM mtl_item_revisions

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

Line 462: FROM mtl_item_revisions

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

Line 542: FROM mtl_item_revisions

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

Line 563: FROM mtl_item_revisions

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