APPS.ENG_VALIDATE_REVISED_ITEM dependencies on MTL_SYSTEM_ITEMS_B

Line 5396: FROM MTL_SYSTEM_ITEMS_B

5392: l_approval_status VARCHAR2(30);
5393:
5394: CURSOR c_approval_status IS
5395: SELECT nvl(approval_status,'A')
5396: FROM MTL_SYSTEM_ITEMS_B
5397: WHERE inventory_item_id = p_item_id
5398: AND organization_id = p_org_id;
5399: BEGIN
5400: OPEN c_approval_status;

Line 6219: l_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;

6215: --Start of changes Bug no:3034642
6216: l_profile_exist BOOLEAN;
6217: l_profile_val VARCHAR2(30);
6218: l_phase_change_code VARCHAR2(30) :='REVISE';
6219: l_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
6220: l_Lifecycle_Id NUMBER;
6221: l_policy_code VARCHAR2(100);
6222: l_Old_Phase_Id mtl_item_revisions_b.current_phase_id%TYPE;
6223: l_Error_Code NUMBER;

Line 6998: FROM mtl_system_items_b i,

6994: ,x_item_catalogue_Group => l_item_catalog_group_id
6995: ,x_item_type => l_item_type);
6996: -- Added bom_parameters, bom_delete_status_code condition for bug 13362684
6997: l_sql := 'SELECT COUNT(*)
6998: FROM mtl_system_items_b i,
6999: bom_parameters bp
7000: WHERE i.organization_id = :1
7001: AND i.inventory_item_status_code not in (''Inactive'', ''Obsolete'')
7002: AND i.inventory_item_status_code <> nvl(bp.bom_delete_status_code, FND_API.G_MISS_CHAR)