eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_ITEM_ATTRIBUTES

Line 344: TYPE ATTRIB_NAME_TAB_TYPE is table of mtl_item_attributes.attribute_name%type index by binary_integer ;

340: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
341:
342: g_atp_flag varchar2(1) := 'N' ;
343:
344: TYPE ATTRIB_NAME_TAB_TYPE is table of mtl_item_attributes.attribute_name%type index by binary_integer ;
345:
346: TYPE CONTROL_LEVEL_TAB_TYPE is table of mtl_item_attributes.control_level%type index by binary_integer ;
347:
348: g_attribute_name_tab ATTRIB_NAME_TAB_TYPE ;

Line 346: TYPE CONTROL_LEVEL_TAB_TYPE is table of mtl_item_attributes.control_level%type index by binary_integer ;

342: g_atp_flag varchar2(1) := 'N' ;
343:
344: TYPE ATTRIB_NAME_TAB_TYPE is table of mtl_item_attributes.attribute_name%type index by binary_integer ;
345:
346: TYPE CONTROL_LEVEL_TAB_TYPE is table of mtl_item_attributes.control_level%type index by binary_integer ;
347:
348: g_attribute_name_tab ATTRIB_NAME_TAB_TYPE ;
349: g_control_level_tab CONTROL_LEVEL_TAB_TYPE ;
350:

Line 9140: from mtl_item_attributes

9136:
9137: select substr( attribute_name, instr( attribute_name, '.' )+ 1 ) , control_level
9138: BULK COLLECT
9139: INTO g_attribute_name_tab, g_control_level_tab
9140: from mtl_item_attributes
9141: where control_level = 1 ;
9142:
9143:
9144: if( get_attribute_control( 'atp_flag' ) = 1 ) then