APPS.PO_DOC_NUMBERING_PKG dependencies on EGO_ATTR_GROUPS_V

Line 191: from ego_attr_groups_v ags

187: END IF;
188:
189: select ags.ATTR_GROUP_NAME
190: into l_attr_group_name
191: from ego_attr_groups_v ags
192: where ags.attr_group_id = l_attrb_grp_id;
193:
194: IF PO_LOG.d_stmt THEN
195: PO_LOG.stmt(d_module, d_progress, 'l_attr_group_name : ', l_attr_group_name);

Line 2799: FROM ego_attr_groups_v

2795: --Get the current attribute group id .
2796:
2797: SELECT attr_group_id
2798: INTO l_cur_attr_group_id
2799: FROM ego_attr_groups_v
2800: WHERE ATTR_GROUP_NAME = 'DOD_AWD'
2801: AND attr_group_type='PO_HEADER_EXT_ATTRS';
2802:
2803: IF(x_dodaac IS NULL AND x_fiscal_year IS NULL AND

Line 5029: ego_attr_groups_v ags,

5025: SELECT puatu.ATTRIBUTE_GROUP_ID, ags.ATTR_GROUP_NAME
5026: INTO l_attr_group_id, l_attr_group_name
5027: FROM PO_UDA_AG_TEMPLATE_USAGES puatu,
5028: po_uda_ag_templates puat,
5029: ego_attr_groups_v ags,
5030: po_headers_all_ext_b phaeb
5031: WHERE puat.ENTITY_CODE=p_ag_type
5032: AND phaeb.po_header_id = p_po_header_id
5033: AND phaeb.draft_id = p_po_draft_id

Line 5286: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags

5282: BEGIN
5283:
5284: SELECT usages.ATTRIBUTE_GROUP_ID , ags.ATTR_GROUP_NAME
5285: INTO l_attrb_grp_id, l_attr_group_name
5286: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags
5287: WHERE usages.template_id = l_template_id
5288: AND usages.ATTRIBUTE1=l_context_usage
5289: AND usages.ATTRIBUTE2=l_source_org_owned
5290: -- bug 13054072 Attribute3 needs to be added here as there may be records that have org_id as well as DEFAULT values in Attribute3 column

Line 5302: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags

5298: --If there is no org_id fetched from po_headers_all
5299:
5300: SELECT usages.ATTRIBUTE_GROUP_ID , ags.ATTR_GROUP_NAME
5301: INTO l_attrb_grp_id, l_attr_group_name
5302: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags
5303: WHERE usages.template_id = l_template_id
5304: AND usages.ATTRIBUTE1=l_context_usage
5305: AND usages.ATTRIBUTE2=l_source_org_owned
5306: AND usages.ATTRIBUTE3='DEFAULT'