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.

APPS.EGO_TEMPL_ATTRS_PUB dependencies on MTL_ITEM_TEMPL_ATTRIBUTES

Line 118: --in mtl_item_templ_attributes with ego_templ_attributes

114:
115: ----------------------------------------------------------------
116: --Sync_Template is a procedure provided to sync up all operational attributes
117: --associated with the template
118: --in mtl_item_templ_attributes with ego_templ_attributes
119: --parameters:
120: -- p_attribute_name is the full attribute name in mtl_item_templ_attributes
121: ----------------------------------------------------------------
122:

Line 120: -- p_attribute_name is the full attribute name in mtl_item_templ_attributes

116: --Sync_Template is a procedure provided to sync up all operational attributes
117: --associated with the template
118: --in mtl_item_templ_attributes with ego_templ_attributes
119: --parameters:
120: -- p_attribute_name is the full attribute name in mtl_item_templ_attributes
121: ----------------------------------------------------------------
122:
123: Procedure Sync_Template( p_template_id IN NUMBER,
124: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 149: MTL_ITEM_TEMPL_ATTRIBUTES ITA

145: ITA.attribute_value
146: FROM
147: EGO_FND_DF_COL_USGS_EXT EXT,
148: EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT,
149: MTL_ITEM_TEMPL_ATTRIBUTES ITA
150: WHERE
151: EXT.descriptive_flex_context_code = FL_CTX_EXT.descriptive_flex_context_code and
152: EXT.application_id = FL_CTX_EXT.application_id and
153: EXT.descriptive_flexfield_name = FL_CTX_EXT.descriptive_flexfield_name and

Line 208: --values in mtl_item_templ_attributes with ego_templ_attributes

204: END Sync_Template;
205:
206: ----------------------------------------------------------------
207: --Sync_Template_Attribute is a procedure provided to sync up operational attribute
208: --values in mtl_item_templ_attributes with ego_templ_attributes
209: --parameters:
210: -- p_attribute_name is the full attribute name in mtl_item_templ_attributes
211: ----------------------------------------------------------------
212:

Line 210: -- p_attribute_name is the full attribute name in mtl_item_templ_attributes

206: ----------------------------------------------------------------
207: --Sync_Template_Attribute is a procedure provided to sync up operational attribute
208: --values in mtl_item_templ_attributes with ego_templ_attributes
209: --parameters:
210: -- p_attribute_name is the full attribute name in mtl_item_templ_attributes
211: ----------------------------------------------------------------
212:
213: Procedure Sync_Template_Attribute
214: ( p_template_id IN NUMBER,

Line 245: r_inv_templ_attribute mtl_item_templ_attributes%ROWTYPE;

241: AND eta.template_id = cp_template_id
242: AND rownum = 1;
243:
244: l_exists NUMBER;
245: r_inv_templ_attribute mtl_item_templ_attributes%ROWTYPE;
246: l_api_name VARCHAR2(30) := 'SYNC_TEMPLATE_ATTRIBUTE-9: ';
247: l_insert VARCHAR2(1);
248: l_attribute_group_id NUMBER;
249: l_data_level_name VARCHAR2(30);

Line 361: --values in mtl_item_templ_attributes with ego_templ_attributes

357: END Sync_Template_Attribute;
358:
359: ----------------------------------------------------------------
360: --Sync_Template_Attribute is a procedure provided to sync up operational attribute
361: --values in mtl_item_templ_attributes with ego_templ_attributes
362: --parameters:
363: -- p_attribute_name is the full attribute name in mtl_item_templ_attributes
364: ----------------------------------------------------------------
365:

Line 363: -- p_attribute_name is the full attribute name in mtl_item_templ_attributes

359: ----------------------------------------------------------------
360: --Sync_Template_Attribute is a procedure provided to sync up operational attribute
361: --values in mtl_item_templ_attributes with ego_templ_attributes
362: --parameters:
363: -- p_attribute_name is the full attribute name in mtl_item_templ_attributes
364: ----------------------------------------------------------------
365:
366: Procedure Sync_Template_Attribute
367: ( p_template_id IN NUMBER,

Line 394: r_inv_templ_attribute mtl_item_templ_attributes%ROWTYPE;

390: AND eta.template_id = cp_template_id
391: AND rownum = 1;
392:
393: l_exists NUMBER;
394: r_inv_templ_attribute mtl_item_templ_attributes%ROWTYPE;
395: l_attribute_group_id NUMBER;
396: l_attribute_id NUMBER;
397: l_insert VARCHAR2(1);
398: l_data_level_id NUMBER;

Line 416: FROM mtl_item_templ_attributes mta

412: Debug_Msg(l_api_name || 'About to collect template data for attribute');
413:
414: SELECT *
415: INTO r_inv_templ_attribute
416: FROM mtl_item_templ_attributes mta
417: WHERE mta.ATTRIBUTE_NAME = p_attribute_name
418: AND mta.template_id = p_template_id;
419:
420: Debug_Msg(l_api_name || 'Collected template data for attribute');