APPS.PO_DATATEMPLATE_PKG dependencies on EGO_ATTR_GROUPS_V

Line 835: from ego_attrs_v eav, ego_attr_groups_v eag

831: l_draftId number;
832: Begin
833:
834: Select eag.attr_group_id, eav.database_column INTO l_attr_grp_id, l_col_name
835: from ego_attrs_v eav, ego_attr_groups_v eag
836: where eav.attr_group_name = 'SHIP_INFO' and eav.attr_group_type = 'PO_SHIPMENTS_EXT_ATTRS'
837: AND eav.ATTR_NAME = 'FOB' and eag.attr_group_name = 'SHIP_INFO' and
838: eag.attr_group_type = 'PO_SHIPMENTS_EXT_ATTRS';
839:

Line 1129: ego_attr_groups_v gr

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
1133: AND gr.attr_group_type = 'PO_HEADER_EXT_ATTRS';

Line 1139: ego_attr_groups_v gr,

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'
1143: AND t1.attribute_group_id = gr.attr_group_id