APPS.PO_AUTOCREATE_PVT dependencies on EGO_ATTR_GROUPS_V

Line 514: FROM ego_attrs_v eav, ego_attr_groups_v eagv

510: d_position := 0;
511:
512: SELECT attr_display_name , eagv.attr_group_id , eav.data_type_code
513: INTO l_attr_display_name , l_attr_group_id , l_data_type_code
514: FROM ego_attrs_v eav, ego_attr_groups_v eagv
515: WHERE eav.attr_group_name = eagv.attr_group_name
516: AND eav.attr_group_type = eagv.attr_group_type
517: AND eav.attr_group_name = p_attr_group_name
518: AND eav.attr_name = p_attr_name

Line 642: (SELECT * FROM ego_attr_groups_v WHERE attr_group_name = 'addresses') eagv ,

638: SELECT DISTINCT eav.attr_group_type|| To_Char( eagv.attr_group_id)|| To_Char(eav.attr_id) ||'LOVDisp'
639: BULK collect
640: INTO p_attr_display_name
641: FROM (SELECT * FROM ego_attrs_v WHERE attr_group_type = 'PO_HEADER_EXT_ATTRS') eav,
642: (SELECT * FROM ego_attr_groups_v WHERE attr_group_name = 'addresses') eagv ,
643: (SELECT * FROM po_entity_differences WHERE mod_doc_source_name = 'PO_ADDRESSES_DRAFT_DIFF_V') ped
644: WHERE eav.attr_group_name = eagv.attr_group_name
645: AND eav.attr_group_type = eagv.attr_group_type
646: AND SubStr(ped.column_name, InStr(ped.column_name, Chr(0))+1) = eav.attr_name

Line 868: FROM ego_attr_groups_v

864: --Insert additional record
865:
866: SELECT attr_group_id
867: INTO l_attr_group_id
868: FROM ego_attr_groups_v
869: WHERE attr_group_name = 'addresses'
870: AND ATTR_GROUP_TYPE = l_attr_group_type;
871:
872: INSERT INTO po_uda_interface