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_REQUEST_LINES_ALL

Line 1043: FROM ozf_sd_request_lines_all

1039: WHERE org_id = p_header_org_id;
1040:
1041: CURSOR c_request_line_id(p_request_line_id IN NUMBER,p_request_header_id IN NUMBER) IS
1042: SELECT request_line_id
1043: FROM ozf_sd_request_lines_all
1044: WHERE request_line_id = p_request_line_id
1045: AND request_header_id = p_request_header_id;
1046:
1047: CURSOR c_inventory_item_id(p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS

Line 1104: FROM ozf_sd_request_lines_all

1100: AND org_id = p_org_id;
1101:
1102: CURSOR c_object_version_number(p_request_line_id IN NUMBER)IS
1103: SELECT object_version_number
1104: FROM ozf_sd_request_lines_all
1105: WHERE request_line_id = p_request_line_id;
1106:
1107: CURSOR c_vendor_item_code(p_supplier_id IN NUMBER
1108: ,p_supplier_site_id IN NUMBER

Line 1184: FROM ozf_sd_request_lines_all

1180: requested_discount_currency,
1181: product_cost_currency,
1182: end_customer_currency,
1183: approved_discount_currency
1184: FROM ozf_sd_request_lines_all
1185: WHERE request_line_id = p_request_line_id;
1186:
1187: BEGIN
1188:

Line 2378: SELECT ozf_sd_request_lines_all_s.nextval

2374: l_req_line_seq NUMBER;
2375:
2376:
2377: CURSOR c_reqest_lines_seq IS
2378: SELECT ozf_sd_request_lines_all_s.nextval
2379: FROM dual;
2380:
2381: BEGIN
2382: -- Initialize API return status to sucess

Line 4488: FROM ozf_sd_request_lines_all

4484: WHERE request_header_id = p_request_header_id;
4485:
4486: CURSOR c_product_flag_check(p_request_header_id IN NUMBER)IS
4487: SELECT COUNT(1)
4488: FROM ozf_sd_request_lines_all
4489: WHERE request_header_id = p_request_header_id;
4490:
4491: CURSOR c_source_sd_lines(p_request_header_id IN NUMBER)IS
4492: SELECT

Line 4534: FROM ozf_sd_request_lines_all

4530: requested_discount_currency,
4531: product_cost_currency,
4532: end_customer_currency,
4533: approved_discount_currency
4534: FROM ozf_sd_request_lines_all
4535: WHERE request_header_id = p_request_header_id;
4536:
4537: CURSOR c_cust_flag_check(p_request_header_id IN NUMBER,p_end_customer_flag IN VARCHAR2)IS
4538: SELECT COUNT(1)