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.IBY_FD_EXTRACT_GEN_PVT dependencies on HZ_CONTACT_POINTS

Line 2065: FROM hz_contact_points

2061:
2062:
2063: CURSOR l_email_csr (p_owner_table_id IN NUMBER) IS
2064: SELECT email_address
2065: FROM hz_contact_points
2066: WHERE owner_table_name = 'HZ_PARTIES'
2067: AND owner_table_id = p_owner_table_id
2068: AND contact_point_type = 'EMAIL'
2069: AND primary_flag = 'Y'

Line 2086: FROM hz_contact_points t

2082: FROM (SELECT t.contact_point_id,
2083: t.primary_flag,
2084: t.phone_line_type,
2085: RANK() OVER (PARTITION BY t.phone_line_type ORDER BY t.primary_flag DESC, t.contact_point_id DESC) primary_phone
2086: FROM hz_contact_points t
2087: WHERE t.owner_table_name = 'HZ_PARTIES'
2088: AND t.owner_table_id = p_owner_table_id
2089: AND t.contact_point_type = 'PHONE'
2090: AND t.phone_line_type = 'GEN'

Line 2101: FROM hz_contact_points t

2097: FROM (SELECT t.contact_point_id,
2098: t.primary_flag,
2099: t.phone_line_type,
2100: RANK() OVER (PARTITION BY t.phone_line_type ORDER BY t.primary_flag DESC, t.contact_point_id DESC) primary_phone
2101: FROM hz_contact_points t
2102: WHERE t.owner_table_name = 'HZ_PARTIES'
2103: AND t.owner_table_id = p_owner_table_id
2104: AND t.contact_point_type = 'PHONE'
2105: AND t.phone_line_type = 'FAX'

Line 2112: FROM hz_contact_points

2108:
2109:
2110: CURSOR l_web_csr (p_owner_table_id IN NUMBER) IS
2111: SELECT url
2112: FROM hz_contact_points
2113: WHERE owner_table_name = 'HZ_PARTIES'
2114: AND owner_table_id = p_owner_table_id
2115: AND contact_point_type = 'WEB'
2116: AND primary_flag = 'Y'

Line 2257: FROM hz_contact_points

2253: WHERE payment_id = p_payment_id;
2254:
2255: CURSOR l_email_csr (p_owner_table_name IN VARCHAR2, p_owner_table_id IN NUMBER) IS
2256: SELECT email_address
2257: FROM hz_contact_points
2258: WHERE owner_table_name = p_owner_table_name
2259: AND owner_table_id = p_owner_table_id
2260: AND contact_point_type = 'EMAIL'
2261: AND primary_flag = 'Y'

Line 2279: FROM hz_contact_points t

2275: FROM (SELECT t.contact_point_id,
2276: t.primary_flag,
2277: t.phone_line_type,
2278: RANK() OVER (PARTITION BY t.phone_line_type ORDER BY t.primary_flag DESC, t.contact_point_id DESC) primary_phone
2279: FROM hz_contact_points t
2280: WHERE t.owner_table_name = p_owner_table_name
2281: AND t.owner_table_id = p_owner_table_id
2282: AND t.contact_point_type = 'PHONE'
2283: AND t.phone_line_type = 'GEN'

Line 2294: FROM hz_contact_points t

2290: FROM (SELECT t.contact_point_id,
2291: t.primary_flag,
2292: t.phone_line_type,
2293: RANK() OVER (PARTITION BY t.phone_line_type ORDER BY t.primary_flag DESC, t.contact_point_id DESC) primary_phone
2294: FROM hz_contact_points t
2295: WHERE t.owner_table_name = p_owner_table_name
2296: AND t.owner_table_id = p_owner_table_id
2297: AND t.contact_point_type = 'PHONE'
2298: AND t.phone_line_type = 'FAX'

Line 2304: FROM hz_contact_points

2300: WHERE x.primary_phone = 1;
2301:
2302: CURSOR l_web_csr (p_owner_table_name IN VARCHAR2, p_owner_table_id IN NUMBER) IS
2303: SELECT url
2304: FROM hz_contact_points
2305: WHERE owner_table_name = p_owner_table_name
2306: AND owner_table_id = p_owner_table_id
2307: AND contact_point_type = 'WEB'
2308: AND primary_flag = 'Y'

Line 2402: FROM hz_contact_points

2398: */
2399:
2400: CURSOR l_email_csr (p_owner_table_name IN VARCHAR2, p_owner_table_id IN NUMBER) IS
2401: SELECT email_address
2402: FROM hz_contact_points
2403: WHERE owner_table_name = p_owner_table_name
2404: AND owner_table_id = p_owner_table_id
2405: AND contact_point_type = 'EMAIL'
2406: AND primary_flag = 'Y'

Line 2424: FROM hz_contact_points t

2420: FROM (SELECT t.contact_point_id,
2421: t.primary_flag,
2422: t.phone_line_type,
2423: RANK() OVER (PARTITION BY t.phone_line_type ORDER BY t.primary_flag DESC, t.contact_point_id DESC) primary_phone
2424: FROM hz_contact_points t
2425: WHERE t.owner_table_name = p_owner_table_name
2426: AND t.owner_table_id = p_owner_table_id
2427: AND t.contact_point_type = 'PHONE'
2428: AND t.phone_line_type = 'GEN'

Line 2439: FROM hz_contact_points t

2435: FROM (SELECT t.contact_point_id,
2436: t.primary_flag,
2437: t.phone_line_type,
2438: RANK() OVER (PARTITION BY t.phone_line_type ORDER BY t.primary_flag DESC, t.contact_point_id DESC) primary_phone
2439: FROM hz_contact_points t
2440: WHERE t.owner_table_name = p_owner_table_name
2441: AND t.owner_table_id = p_owner_table_id
2442: AND t.contact_point_type = 'PHONE'
2443: AND t.phone_line_type = 'FAX'

Line 2449: FROM hz_contact_points

2445: WHERE x.primary_phone = 1;
2446:
2447: CURSOR l_web_csr (p_owner_table_name IN VARCHAR2, p_owner_table_id IN NUMBER) IS
2448: SELECT url
2449: FROM hz_contact_points
2450: WHERE owner_table_name = p_owner_table_name
2451: AND owner_table_id = p_owner_table_id
2452: AND contact_point_type = 'WEB'
2453: AND primary_flag = 'Y'