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.POR_AMENDMENT_PKG dependencies on EGO_ATTR_GROUPS_V

Line 277: ego_attr_groups_v ag

273: SELECT u.attribute_group_id, ag.attr_group_name
274: INTO g_address_attr_group_id, g_address_group_name
275: FROM po_uda_ag_template_usages u,
276: po_requisition_headers_all h,
277: ego_attr_groups_v ag
278: WHERE h.uda_template_id = u.template_id
279: AND h.requisition_header_id = p_confirmed_id
280: AND ag.attr_group_type = 'PO_REQ_HEADER_EXT_ATTRS'
281: AND ag.attr_group_id = u.attribute_group_id

Line 509: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags

505:
506: IF p_level = 'UDA_HEADER' THEN
507: SELECT ags.ATTR_GROUP_NAME
508: INTO x_doc_number_attr_group_name
509: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags
510: WHERE usages.template_id = x_template_id
511: AND usages.ATTRIBUTE1='Base Document'
512: AND usages.ATTRIBUTE2='NA'
513: -- bug 14248325 Attribute3 needs to be added here as there may be records that have org_id as well as DEFAULT values in Attribute3 column

Line 528: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags

524: --If there is no attribute group name fetched with the org_id from po_requisition_headers_all then go for DEFAULT
525:
526: SELECT ags.ATTR_GROUP_NAME
527: INTO x_doc_number_attr_group_name
528: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags
529: WHERE usages.template_id = x_template_id
530: AND usages.ATTRIBUTE1='Base Document'
531: AND usages.ATTRIBUTE2='NA'
532: AND usages.ATTRIBUTE3='DEFAULT'