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 148: MTL_ITEM_TEMPL_ATTRIBUTES ITA

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

Line 207: --values in mtl_item_templ_attributes with ego_templ_attributes

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

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

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

Line 244: r_inv_templ_attribute mtl_item_templ_attributes%ROWTYPE;

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

Line 360: --values in mtl_item_templ_attributes with ego_templ_attributes

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

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

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

Line 393: r_inv_templ_attribute mtl_item_templ_attributes%ROWTYPE;

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

Line 415: FROM mtl_item_templ_attributes mta

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