DBA Data[Home] [Help]

APPS.POR_UDA_PKG dependencies on EGO_ATTR_GROUPS_V

Line 699: FROM EGO_ATTR_GROUPS_V

695: FOR c_get_add_agids_tbl_rec IN c_get_add_agids_tbl(l_template_id) LOOP
696: l_attribute_group_table.extend(1);
697:
698: SELECT attr_group_name INTO l_attr_group_name
699: FROM EGO_ATTR_GROUPS_V
700: WHERE ATTR_GROUP_TYPE = 'PO_REQ_HEADER_EXT_ATTRS' AND ATTR_GROUP_ID = c_get_add_agids_tbl_rec.ATTRIBUTE_GROUP_ID;
701:
702: l_attribute_group_table(l_attribute_group_table.Count) := l_attr_group_name;
703:

Line 1186: PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags

1182: SELECT extension_id, EGO_EXTFWK_S.NEXTVAL
1183: FROM PO_REQ_HEADERS_EXT_B
1184: WHERE REQUISITION_HEADER_ID = p_old_header_id
1185: AND ATTR_GROUP_ID in ( SELECT ATTR_GROUP_ID FROM
1186: PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags
1187: WHERE usages.template_id = p_template_id
1188: AND usages.ATTRIBUTE1='Base Document'
1189: AND usages.ATTRIBUTE2='NA'
1190: AND usages.ATTRIBUTE_CATEGORY='DOCUMENT_NUMBERING'