APPS.INVIDIT3 dependencies on MTL_ITEM_ATTRIBUTES

Line 214: FROM mtl_item_attributes

210: END IF;
211:
212: --6531911 : Removed multiple select stmts into one cursor stmt
213: FOR cur IN (SELECT control_level, attribute_name
214: FROM mtl_item_attributes
215: WHERE attribute_name IN ('MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE'
216: ,'MTL_SYSTEM_ITEMS.SHELF_LIFE_CODE'
217: ,'MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE'
218: ,'MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE'

Line 804: from mtl_item_attributes

800: declare /*Changes made for perf issue for bug 7567261*/
801: shipping_level NUMBER :=0;
802: begin
803: select count(1) into shipping_level
804: from mtl_item_attributes
805: where control_level = 1
806: and attribute_name=attr_name;
807:
808: if (shipping_level = 0) then

Line 933: from mtl_item_attributes

929: (select organization_id
930: from mtl_parameters
931: where master_organization_id = p_master_org
932: and 1=(select control_level
933: from mtl_item_attributes
934: where
935: attribute_name='MTL_SYSTEM_ITEMS.SO_TRANSACTIONS_FLAG'
936: )
937: )

Line 1021: from mtl_item_attributes

1017: (select organization_id
1018: from mtl_parameters
1019: where master_organization_id = p_master_org
1020: and 1 = (select control_level
1021: from mtl_item_attributes
1022: where attribute_name= 'MTL_SYSTEM_ITEMS.ATP_FLAG')
1023: )
1024: or bom.organization_id = p_org_id)
1025: and rownum = 1;