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

Line 477: FROM dual

473: WHERE uom_code = p_uom_code;
474:
475: CURSOR c_category_chk (p_category_id IN NUMBER) IS
476: SELECT 'Y'
477: FROM dual
478: WHERE EXISTS(SELECT 1
479: FROM eni_denorm_hierarchies
480: WHERE parent_id = p_category_id);
481:

Line 2679: FROM dual;

2675: l_root_request_header_id NUMBER;
2676:
2677: CURSOR c_reqest_header_seq IS
2678: SELECT OZF_SD_REQUEST_HEADERS_ALL_B_S.nextval
2679: FROM dual;
2680:
2681: CURSOR c_code_prefix(p_request_type_setup_id IN NUMBER) IS
2682: SELECT source_code_suffix
2683: FROM ams_custom_setups_vl

Line 2916: FROM dual;

2912: WHERE request_line_id = p_request_line_id;
2913:
2914: CURSOR c_reqest_lines_seq IS
2915: SELECT ozf_sd_request_lines_all_s.nextval
2916: FROM dual;
2917:
2918: BEGIN
2919: -- Initialize API return status to sucess
2920: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3113: FROM dual;

3109: l_cust_count NUMBER;
3110:
3111: CURSOR c_reqest_cust_seq IS
3112: SELECT OZF_SD_CUSTOMER_DETAILS_S.nextval
3113: FROM dual;
3114:
3115: CURSOR c_cust_details(p_request_header_id IN NUMBER
3116: ,p_cust_usage_code IN VARCHAR2
3117: ,p_party_id IN NUMBER