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_RELATIONSHIP_TYPES

Line 532: AND owner_table_name = 'HZ_RELATIONSHIP_TYPES'

528: ) IS
529: SELECT 1
530: FROM hz_dss_criteria
531: WHERE dss_group_code = p_dss_group_code
532: AND owner_table_name = 'HZ_RELATIONSHIP_TYPES'
533: AND status = 'A'
534: AND ROWNUM = 1;
535:
536: CURSOR c_get_dss_groups (

Line 1849: FROM hz_relationship_types rt

1845: AND rel.relationship_id = p_relationship_id -- added for Bug 5687869
1846: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
1847: SELECT relationship_type, forward_rel_code,
1848: subject_type, object_type
1849: FROM hz_relationship_types rt
1850: WHERE rt.relationship_type_id = p_relationship_type_id)
1851: AND SYSDATE BETWEEN
1852: NVL(start_date, SYSDATE) AND NVL(end_date, SYSDATE)
1853: AND status = 'A'

Line 1866: FROM hz_relationship_types rt

1862: AND rel.directional_flag = 'F'
1863: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
1864: SELECT relationship_type, forward_rel_code,
1865: subject_type, object_type
1866: FROM hz_relationship_types rt
1867: WHERE rt.relationship_type_id = p_relationship_type_id)
1868: AND SYSDATE BETWEEN
1869: NVL(rel.start_date, SYSDATE) AND NVL(rel.end_date, SYSDATE)
1870: AND rel.status = 'A'

Line 1878: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

1874: p_dss_group_code VARCHAR2
1875: ) IS
1876: SELECT owner_table_id1
1877: FROM hz_dss_criteria dsc
1878: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
1879: AND dsc.dss_group_code = p_dss_group_code
1880: AND dsc.status = 'A';
1881:
1882: l_falling_into_the_group VARCHAR2(2);

Line 2006: FROM hz_relationship_types rt, hz_dss_criteria dsc

2002: AND rel.relationship_id = p_object_pk1 --(Bug 5687869)
2003: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2004: SELECT relationship_type, forward_rel_code,
2005: subject_type, object_type
2006: FROM hz_relationship_types rt, hz_dss_criteria dsc
2007: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
2008: AND dsc.dss_group_code = p_dss_group_code
2009: AND dsc.owner_table_id1 = rt.relationship_type_id
2010: AND dsc.status = 'A' )

Line 2007: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

2003: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2004: SELECT relationship_type, forward_rel_code,
2005: subject_type, object_type
2006: FROM hz_relationship_types rt, hz_dss_criteria dsc
2007: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
2008: AND dsc.dss_group_code = p_dss_group_code
2009: AND dsc.owner_table_id1 = rt.relationship_type_id
2010: AND dsc.status = 'A' )
2011: AND SYSDATE BETWEEN

Line 2032: FROM hz_relationship_types rt, hz_dss_criteria dsc

2028: AND rel.directional_flag = 'F'
2029: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2030: SELECT relationship_type, forward_rel_code,
2031: subject_type, object_type
2032: FROM hz_relationship_types rt, hz_dss_criteria dsc
2033: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
2034: AND dsc.dss_group_code = p_dss_group_code
2035: AND dsc.owner_table_id1 = rt.relationship_type_id
2036: AND dsc.status = 'A')

Line 2033: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

2029: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2030: SELECT relationship_type, forward_rel_code,
2031: subject_type, object_type
2032: FROM hz_relationship_types rt, hz_dss_criteria dsc
2033: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
2034: AND dsc.dss_group_code = p_dss_group_code
2035: AND dsc.owner_table_id1 = rt.relationship_type_id
2036: AND dsc.status = 'A')
2037: AND SYSDATE BETWEEN

Line 2051: FROM hz_relationship_types rt, hz_dss_criteria dsc

2047: AND rel.directional_flag = 'F'
2048: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2049: SELECT relationship_type, forward_rel_code,
2050: subject_type, object_type
2051: FROM hz_relationship_types rt, hz_dss_criteria dsc
2052: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
2053: AND dsc.dss_group_code = p_dss_group_code
2054: AND dsc.owner_table_id1 = rt.relationship_type_id
2055: AND dsc.status = 'A')

Line 2052: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

2048: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2049: SELECT relationship_type, forward_rel_code,
2050: subject_type, object_type
2051: FROM hz_relationship_types rt, hz_dss_criteria dsc
2052: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
2053: AND dsc.dss_group_code = p_dss_group_code
2054: AND dsc.owner_table_id1 = rt.relationship_type_id
2055: AND dsc.status = 'A')
2056: AND SYSDATE BETWEEN