DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on MTL_ITEM_REVISIONS

Line 4647: FROM mtl_item_revisions

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

Line 4781: FROM mtl_item_revisions

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

Line 4903: FROM mtl_item_revisions

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

Line 10383: FROM mtl_item_revisions

10379:
10380: CURSOR get_version_id IS
10381: SELECT revision_id
10382: INTO l_platform_Version_id
10383: FROM mtl_item_revisions
10384: WHERE organization_id = p_organization_id
10385: AND inventory_item_id = p_platform_id
10386: AND revision_id = p_platform_Version_id ;
10387: