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 973: FROM fnd_objects fo , hz_dss_entities dse

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

Line 988: l_entity_id hz_dss_entities.entity_id%type;

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

Line 989: l_object_id hz_dss_entities.object_id%type;

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

Line 992: l_parent_fk_column1 hz_dss_entities.parent_fk_column1%type;

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

Line 993: l_parent_fk_column2 hz_dss_entities.parent_fk_column2%type;

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

Line 994: l_group_assignment_level hz_dss_entities.group_assignment_level%type;

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

Line 1108: FROM fnd_objects fo , hz_dss_entities dse

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

Line 1359: hz_dss_entities dse

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

Line 1373: hz_dss_entities dse

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