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.OZF_OFFER_PVT dependencies on OZF_SD_CUSTOMER_DETAILS

Line 11033: FROM ozf_sd_customer_details

11029: CURSOR cur_get_cust_qual_lines IS
11030: SELECT request_customer_id,party_id,
11031: cust_account_id,site_use_id,
11032: cust_usage_code,end_customer_flag
11033: FROM ozf_sd_customer_details
11034: WHERE request_header_id = p_sdr_header_id;
11035:
11036: CURSOR cur_get_end_cust_qual_lines IS
11037: SELECT request_customer_id,party_id,

Line 11040: FROM ozf_sd_customer_details

11036: CURSOR cur_get_end_cust_qual_lines IS
11037: SELECT request_customer_id,party_id,
11038: cust_account_id,site_use_id,
11039: cust_usage_code,end_customer_flag
11040: FROM ozf_sd_customer_details
11041: WHERE request_header_id = p_sdr_header_id;
11042:
11043: CURSOR cur_get_end_cust_count IS
11044: SELECT count(request_customer_id)

Line 11045: FROM ozf_sd_customer_details

11041: WHERE request_header_id = p_sdr_header_id;
11042:
11043: CURSOR cur_get_end_cust_count IS
11044: SELECT count(request_customer_id)
11045: FROM ozf_sd_customer_details
11046: WHERE request_header_id = p_sdr_header_id
11047: AND end_customer_flag = 'Y';
11048:
11049: CURSOR cur_get_old_qualifiers IS