APPS.INV_EGO_REVISION_VALIDATE dependencies on MTL_ITEM_ATTRIBUTES

Line 555: FROM mtl_item_attributes

551: WHERE organization_id = master_organization_id);
552:
553: CURSOR c_get_control_level IS
554: SELECT control_level
555: FROM mtl_item_attributes
556: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
557:
558:
559: l_Master_Phase_Id mtl_system_items_b.current_phase_id%TYPE;

Line 2454: FOR cur in ( select substr(attribute_name, 18) att_name from MTL_ITEM_ATTRIBUTES WHERE STATUS_CONTROL_CODE IN (1,2) ) LOOP

2450: x_msg_data => l_msg_data);
2451:
2452: -- Bug 14285936 begin
2453: IF ( p_application_column_name = 'INVENTORY_ITEM_STATUS_CODE' ) THEN
2454: FOR cur in ( select substr(attribute_name, 18) att_name from MTL_ITEM_ATTRIBUTES WHERE STATUS_CONTROL_CODE IN (1,2) ) LOOP
2455: EGO_EXT_FWK_PUB.Update_Attribute_Control_Level(
2456: p_api_version => 1,
2457: p_application_id => 431,
2458: p_descriptive_flexfield_name => 'EGO_MASTER_ITEMS' ,