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.PO_DOC_UDA_UTIL dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 39: select distinct(attribute_category) from po_uda_ag_template_usages

35: l_attr_grp_ids PO_TBL_NUMBER;
36: t_count NUMBER;
37:
38: cursor c_get_usages(p_template_id number) is
39: select distinct(attribute_category) from po_uda_ag_template_usages
40: where template_id = p_template_id;
41:
42: BEGIN
43: IF (PO_LOG.d_proc) THEN

Line 123: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages

119: t_count NUMBER;
120: l_count NUMBER;
121:
122: CURSOR c_get_usages(p_template_id NUMBER) IS
123: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
124: WHERE template_id = p_template_id;
125:
126: BEGIN
127:

Line 233: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages

229: l_attr_grp_ids PO_TBL_NUMBER;
230: t_count NUMBER;
231:
232: CURSOR c_get_usages(p_template_id NUMBER) IS
233: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
234: WHERE template_id = p_template_id;
235:
236: BEGIN
237: IF (PO_LOG.d_proc) THEN

Line 310: FROM po_uda_ag_template_usages

306:
307: CURSOR c_get_add_agids_tbl(l_template_id NUMBER)
308: IS
309: SELECT ATTRIBUTE_GROUP_ID
310: FROM po_uda_ag_template_usages
311: WHERE template_id = l_template_id
312: AND ATTRIBUTE_CATEGORY IN ('ADDRESS', 'DOCUMENT_NUMBERING','MODIFICATIONS');
313: BEGIN
314: IF (PO_LOG.d_proc) THEN