APPS.ENG_VALIDATE_REVISED_ITEM dependencies on MTL_SYSTEM_ITEMS_B

Line 5315: FROM MTL_SYSTEM_ITEMS_B

5311: l_approval_status VARCHAR2(30);
5312:
5313: CURSOR c_approval_status IS
5314: SELECT nvl(approval_status,'A')
5315: FROM MTL_SYSTEM_ITEMS_B
5316: WHERE inventory_item_id = p_item_id
5317: AND organization_id = p_org_id;
5318: BEGIN
5319: OPEN c_approval_status;

Line 6133: l_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;

6129: --Start of changes Bug no:3034642
6130: l_profile_exist BOOLEAN;
6131: l_profile_val VARCHAR2(30);
6132: l_phase_change_code VARCHAR2(30) :='REVISE';
6133: l_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
6134: l_Lifecycle_Id NUMBER;
6135: l_policy_code VARCHAR2(100);
6136: l_Old_Phase_Id mtl_item_revisions_b.current_phase_id%TYPE;
6137: l_Error_Code NUMBER;

Line 6911: FROM mtl_system_items_b

6907: ,x_item_lifecycle_Phase => l_current_phase_id
6908: ,x_item_catalogue_Group => l_item_catalog_group_id
6909: ,x_item_type => l_item_type);
6910: l_sql := 'SELECT COUNT(*)
6911: FROM mtl_system_items_b
6912: WHERE organization_id = :1
6913: AND inventory_item_status_code not in (''Inactive'', ''Obsolete'')
6914: AND inventory_item_id = :2';
6915: if l_current_phase_id IS NOT NULL then