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 OZF_SD_CUSTOMER_DETAILS

Line 2233: FROM ozf_sd_customer_details

2229:
2230:
2231: CURSOR c_request_customer_id(p_request_customer_id IN NUMBER,p_request_header_id IN NUMBER)IS
2232: SELECT request_customer_id
2233: FROM ozf_sd_customer_details
2234: WHERE request_customer_id = p_request_customer_id
2235: AND request_header_id = p_request_header_id ;
2236:
2237: CURSOR c_party_id(p_party_id IN NUMBER)IS

Line 2290: FROM ozf_sd_customer_details

2286: attribute14,
2287: attribute15,
2288: end_customer_flag,
2289: cust_usage_value
2290: FROM ozf_sd_customer_details
2291: WHERE request_customer_id = p_request_customer_id;
2292:
2293: CURSOR c_buying_group(p_party_id IN NUMBER)IS
2294: SELECT party_id

Line 3112: SELECT OZF_SD_CUSTOMER_DETAILS_S.nextval

3108: l_request_cust_seq NUMBER;
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

Line 3123: FROM ozf_sd_customer_details

3119: ,p_site_use_id IN NUMBER --//Bugfix :8724614
3120: ,p_end_customer_flag IN VARCHAR2
3121: ,p_cust_usage_value IN VARCHAR2)IS
3122: SELECT COUNT(1)
3123: FROM ozf_sd_customer_details
3124: WHERE request_header_id = p_request_header_id
3125: AND cust_usage_code = p_cust_usage_code
3126: AND party_id = p_party_id
3127: AND cust_account_id = p_cust_account_id

Line 5123: FROM ozf_sd_customer_details

5119: WHERE request_header_id = p_request_header_id;
5120:
5121: CURSOR c_cust_flag_check(p_request_header_id IN NUMBER,p_end_customer_flag IN VARCHAR2)IS
5122: SELECT COUNT(1)
5123: FROM ozf_sd_customer_details
5124: WHERE request_header_id = p_request_header_id
5125: AND end_customer_flag = p_end_customer_flag;
5126:
5127: CURSOR c_source_customer_dtl(p_request_header_id IN NUMBER,p_end_customer_flag IN VARCHAR2)IS

Line 5151: FROM ozf_sd_customer_details

5147: attribute14,
5148: attribute15,
5149: end_customer_flag,
5150: cust_usage_value
5151: FROM ozf_sd_customer_details
5152: WHERE request_header_id = p_request_header_id
5153: AND end_customer_flag = p_end_customer_flag;
5154:
5155: CURSOR c_authorization_period(p_supplier_id IN NUMBER,