DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on MTL_ITEM_REVISIONS

Line 4645: FROM mtl_item_revisions

4641: IF l_rev_control_code = 2 THEN
4642: BEGIN
4643: SELECT 'x'
4644: INTO l_test
4645: FROM mtl_item_revisions
4646: WHERE inventory_item_id = p_inventory_item_id
4647: AND organization_id = p_inventory_org_id
4648: AND revision = p_inv_item_revision;
4649:

Line 4779: FROM mtl_item_revisions

4775:
4776: IF l_rev_control_code = 2 THEN
4777: SELECT 'x'
4778: INTO l_test
4779: FROM mtl_item_revisions
4780: WHERE organization_id = p_inventory_org_id
4781: AND inventory_item_id = p_inv_component_id
4782: AND revision = p_inv_component_version ;
4783: END IF;

Line 4901: FROM mtl_item_revisions

4897:
4898: IF l_rev_control_code = 2 THEN
4899: SELECT 'x'
4900: INTO l_test
4901: FROM mtl_item_revisions
4902: WHERE organization_id = p_inventory_org_id
4903: AND inventory_item_id = p_inv_subcomponent_id
4904: AND revision = p_inv_subcomponent_version ;
4905: END IF;

Line 10303: FROM mtl_item_revisions

10299:
10300: CURSOR get_version_id IS
10301: SELECT revision_id
10302: INTO l_platform_Version_id
10303: FROM mtl_item_revisions
10304: WHERE organization_id = p_organization_id
10305: AND inventory_item_id = p_platform_id
10306: AND revision_id = p_platform_Version_id ;
10307: