DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_PVT dependencies on EGO_ATTRS_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 641: FROM (SELECT * FROM ego_attrs_v WHERE attr_group_type = 'PO_HEADER_EXT_ATTRS') eav,

637:
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

Line 811: FROM ego_attrs_v

807: BEGIN
808:
809: SELECT value_set_name
810: INTO l_value_set
811: FROM ego_attrs_v
812: WHERE attr_group_type = l_attr_group_type
813: AND attr_name =l_attr_name
814: AND ATTR_GROUP_NAME = 'addresses';
815: