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_DATATEMPLATE_PKG dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 253: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU

249: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
250: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
251: AG.MULTI_ROW MULTI_ROW
252: FROM EGO_FND_DSC_FLX_CTX_EXT AG,
253: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
254: WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
255: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
256: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
257: AND potu.attribute_group_id in (select distinct attr_group_id

Line 350: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU

346: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
347: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
348: AG.MULTI_ROW MULTI_ROW
349: FROM EGO_FND_DSC_FLX_CTX_EXT AG,
350: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
351: WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
352: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
353: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
354: AND potu.attribute_group_id in (select distinct attr_group_id

Line 451: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU

447: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
448: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
449: AG.MULTI_ROW MULTI_ROW
450: FROM EGO_FND_DSC_FLX_CTX_EXT AG,
451: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
452: WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
453: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
454: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
455: AND potu.attribute_group_id in (select distinct attr_group_id

Line 1128: FROM po_uda_ag_template_usages t1,

1124: po_attr_uda_xml XMLTYPE;
1125: CURSOR curr_uda_groups IS
1126: SELECT gr.attr_group_name,
1127: t1.attribute_group_id
1128: FROM po_uda_ag_template_usages t1,
1129: ego_attr_groups_v gr
1130: WHERE t1.template_id = p_template_id
1131: AND t1.attribute_category = 'CLOSEOUT'
1132: AND t1.attribute_group_id = gr.attr_group_id

Line 1138: FROM po_uda_ag_template_usages t1,

1134: CURSOR curr_uda_columns (
1135: p_attr_group_id NUMBER) IS
1136: SELECT val.attr_name,
1137: val.database_column
1138: FROM po_uda_ag_template_usages t1,
1139: ego_attr_groups_v gr,
1140: ego_attrs_v val
1141: WHERE t1.template_id = p_template_id
1142: AND t1.attribute_category = 'CLOSEOUT'