[Home] [Help]
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
563: WHERE obj.database_object_name = p_db_object_name
564: AND dse.object_id IS NULL
565: AND dse.instance_set_id = ins.instance_set_id
566: AND ins.object_id = obj.object_id
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
978: from fnd_object_instance_sets ois
979: where ois.object_id IN
980: (select object_id from fnd_objects
981: where database_object_name = t_object_name)
982: )
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
1113: fo.object_id = ( select distinct object_id from fnd_object_instance_sets
1114: where instance_set_id = dse.instance_set_id))
1115: AND dse.parent_entity_id = t_entity_id
1116: AND dse.status = 'A'
1117: order by dse.entity_id;
1367: decode(pk2_column_name , null,null, ','|| pk2_column_name) ||
1368: decode(pk3_column_name , null,null, ','|| pk3_column_name) ||
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'
2282: WHERE obj_name = p_object_name;
2283:
2284: CURSOR c_object_instance_sets IS
2285: SELECT display_name
2286: FROM fnd_object_instance_sets_vl
2287: WHERE instance_set_name = p_object_instance_name;
2288:
2289: l_return VARCHAR2(300);
2290: