eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_DSS_UTIL_PUB dependencies on HZ_DSS_ENTITIES

Line 542: FROM hz_dss_entities dse,

538: ) IS
539: SELECT obj.object_id, obj.obj_name, null instance_set_id, null instance_set_name,
540: obj.pk1_column_name, obj.pk2_column_name, null predicate,
541: dsg.dss_group_code, dsg.rank
542: FROM hz_dss_entities dse,
543: hz_dss_secured_entities se,
544: hz_dss_groups_b dsg,
545: fnd_objects obj
546: WHERE obj.database_object_name = p_db_object_name

Line 558: FROM hz_dss_entities dse,

554: UNION ALL
555: SELECT obj.object_id, obj.obj_name, ins.instance_set_id, ins.instance_set_name,
556: obj.pk1_column_name, obj.pk2_column_name, ins.predicate,
557: dsg.dss_group_code, dsg.rank
558: FROM hz_dss_entities dse,
559: hz_dss_secured_entities se,
560: hz_dss_groups_b dsg,
561: fnd_objects obj,
562: fnd_object_instance_sets ins

Line 972: FROM fnd_objects fo , hz_dss_entities dse

968: SELECT dse.entity_id, fo.object_id,
969: fo.pk1_column_name, fo.pk2_column_name ,
970: dse.parent_fk_column1 , dse.parent_fk_column2,
971: dse.group_assignment_level
972: FROM fnd_objects fo , hz_dss_entities dse
973: WHERE ( ( dse.object_id IN ( select object_id from fnd_objects
974: where database_object_name = t_object_name) )
975: OR
976: (dse.instance_set_id in ( select instance_set_id

Line 987: l_entity_id hz_dss_entities.entity_id%type;

983: )
984: AND fo.object_id = dse.object_id
985: AND dse.status = 'A';
986:
987: l_entity_id hz_dss_entities.entity_id%type;
988: l_object_id hz_dss_entities.object_id%type;
989: l_pk1_column_name fnd_objects.pk1_column_name%type;
990: l_pk2_column_name fnd_objects.pk2_column_name%type;
991: l_parent_fk_column1 hz_dss_entities.parent_fk_column1%type;

Line 988: l_object_id hz_dss_entities.object_id%type;

984: AND fo.object_id = dse.object_id
985: AND dse.status = 'A';
986:
987: l_entity_id hz_dss_entities.entity_id%type;
988: l_object_id hz_dss_entities.object_id%type;
989: l_pk1_column_name fnd_objects.pk1_column_name%type;
990: l_pk2_column_name fnd_objects.pk2_column_name%type;
991: l_parent_fk_column1 hz_dss_entities.parent_fk_column1%type;
992: l_parent_fk_column2 hz_dss_entities.parent_fk_column2%type;

Line 991: l_parent_fk_column1 hz_dss_entities.parent_fk_column1%type;

987: l_entity_id hz_dss_entities.entity_id%type;
988: l_object_id hz_dss_entities.object_id%type;
989: l_pk1_column_name fnd_objects.pk1_column_name%type;
990: l_pk2_column_name fnd_objects.pk2_column_name%type;
991: l_parent_fk_column1 hz_dss_entities.parent_fk_column1%type;
992: l_parent_fk_column2 hz_dss_entities.parent_fk_column2%type;
993: l_group_assignment_level hz_dss_entities.group_assignment_level%type;
994: l_dsg_code hz_dss_secured_entities.dss_group_code%type;
995: l_sql varchar2(2000);

Line 992: l_parent_fk_column2 hz_dss_entities.parent_fk_column2%type;

988: l_object_id hz_dss_entities.object_id%type;
989: l_pk1_column_name fnd_objects.pk1_column_name%type;
990: l_pk2_column_name fnd_objects.pk2_column_name%type;
991: l_parent_fk_column1 hz_dss_entities.parent_fk_column1%type;
992: l_parent_fk_column2 hz_dss_entities.parent_fk_column2%type;
993: l_group_assignment_level hz_dss_entities.group_assignment_level%type;
994: l_dsg_code hz_dss_secured_entities.dss_group_code%type;
995: l_sql varchar2(2000);
996:

Line 993: l_group_assignment_level hz_dss_entities.group_assignment_level%type;

989: l_pk1_column_name fnd_objects.pk1_column_name%type;
990: l_pk2_column_name fnd_objects.pk2_column_name%type;
991: l_parent_fk_column1 hz_dss_entities.parent_fk_column1%type;
992: l_parent_fk_column2 hz_dss_entities.parent_fk_column2%type;
993: l_group_assignment_level hz_dss_entities.group_assignment_level%type;
994: l_dsg_code hz_dss_secured_entities.dss_group_code%type;
995: l_sql varchar2(2000);
996:
997:

Line 1107: FROM fnd_objects fo , hz_dss_entities dse

1103: fo.database_object_name,
1104: fo.pk1_column_name,
1105: fo.pk2_column_name ,
1106: dse.parent_entity_id , dse.parent_fk_column1 , dse.parent_fk_column2
1107: FROM fnd_objects fo , hz_dss_entities dse
1108: WHERE parent_entity_id is not null
1109: AND ( dse.object_id is not null and
1110: fo.object_id = dse.object_id )
1111: OR (dse.instance_set_id is not null and

Line 1358: hz_dss_entities dse

1354: decode(pk3_column_name , null,null, ','|| pk3_column_name) ||
1355: decode(pk4_column_name , null,null, ','|| pk4_column_name) ||
1356: decode(pk5_column_name , null,null, ','|| pk5_column_name)
1357: FROM fnd_objects obj,
1358: hz_dss_entities dse
1359: WHERE dse.entity_id = p_entity_id
1360: AND dse.status = 'A'
1361: AND dse.object_id IS NOT NULL
1362: AND dse.object_id = obj.object_id

Line 1372: hz_dss_entities dse

1368: decode(pk4_column_name , null,null, ','|| pk4_column_name) ||
1369: decode(pk5_column_name , null,null, ','|| pk5_column_name)
1370: FROM fnd_object_instance_sets ins,
1371: fnd_objects obj,
1372: hz_dss_entities dse
1373: WHERE dse.entity_id = p_entity_id
1374: AND dse.status = 'A'
1375: AND dse.instance_set_id IS NOT NULL
1376: AND dse.instance_set_id = ins.instance_set_id