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_CUSTOMER_INT dependencies on DUAL

Line 1557: from dual;

1553: ELSIF l_no_segments = 2 THEN
1554:
1555: select
1556: rtrim(substr(l_struct,1,instr(l_struct,'.')),'.'),ltrim(substr(l_struct,instr(l_struct,'.')),'.') into l_child,l_parent
1557: from dual;
1558:
1559: IF (l_struct = 'CITY.STATE') then
1560: l_child_value := p_city;
1561: l_parent_value := p_state;

Line 2107: FROM DUAL

2103:
2104: BEGIN
2105: SELECT 'Y'
2106: INTO l_loc_assignment_exist
2107: FROM DUAL
2108: WHERE EXISTS (SELECT 1
2109: FROM hz_loc_assignments la
2110: WHERE la.location_id = l_location_id
2111: );

Line 2114: FROM DUAL

2110: WHERE la.location_id = l_location_id
2111: );
2112: SELECT 'Y'
2113: INTO l_is_remit_to_location
2114: FROM DUAL
2115: WHERE EXISTS (SELECT 1
2116: FROM hz_party_sites ps
2117: WHERE ps.location_id = l_location_id
2118: AND ps.party_id = -1

Line 2286: FROM dual

2282: g_request_id,
2283: g_program_application_id,
2284: g_program_id,
2285: SYSDATE
2286: FROM dual
2287: WHERE NOT EXISTS (
2288: SELECT 'Y'
2289: FROM hz_win_source_exceps
2290: WHERE party_id = i_party_id(i)