APPS.OZF_SD_REQUEST_PUB dependencies on OZF_SD_REQUEST_LINES_ALL

Line 1243: FROM ozf_sd_request_lines_all

1239: WHERE org_id = p_header_org_id;
1240:
1241: CURSOR c_request_line_id(p_request_line_id IN NUMBER,p_request_header_id IN NUMBER) IS
1242: SELECT request_line_id
1243: FROM ozf_sd_request_lines_all
1244: WHERE request_line_id = p_request_line_id
1245: AND request_header_id = p_request_header_id;
1246:
1247: CURSOR c_inventory_item_id(p_inventory_item_id IN NUMBER,p_org_id IN NUMBER)IS

Line 1338: FROM ozf_sd_request_lines_all

1334: AND org_id = p_org_id;
1335:
1336: CURSOR c_object_version_number(p_request_line_id IN NUMBER)IS
1337: SELECT object_version_number
1338: FROM ozf_sd_request_lines_all
1339: WHERE request_line_id = p_request_line_id;
1340:
1341: CURSOR c_vendor_item_code(p_supplier_id IN NUMBER
1342: ,p_supplier_site_id IN NUMBER

Line 1418: FROM ozf_sd_request_lines_all

1414: requested_discount_currency,
1415: product_cost_currency,
1416: end_customer_currency,
1417: approved_discount_currency
1418: FROM ozf_sd_request_lines_all
1419: WHERE request_line_id = p_request_line_id;
1420:
1421: BEGIN
1422:

Line 2911: FROM ozf_sd_request_lines_all

2907:
2908:
2909: CURSOR c_val_reqest_lines_seq(p_request_line_id NUMBER) IS
2910: SELECT -1
2911: FROM ozf_sd_request_lines_all
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

Line 2915: SELECT ozf_sd_request_lines_all_s.nextval

2911: FROM ozf_sd_request_lines_all
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

Line 5072: FROM ozf_sd_request_lines_all

5068: WHERE request_header_id = p_request_header_id;
5069:
5070: CURSOR c_product_flag_check(p_request_header_id IN NUMBER)IS
5071: SELECT COUNT(1)
5072: FROM ozf_sd_request_lines_all
5073: WHERE request_header_id = p_request_header_id;
5074:
5075: --backdated Adjustment ER , the lines that are end dated and restricted via qualifier should not be copied.
5076: CURSOR c_source_sd_lines(p_request_header_id IN NUMBER)IS

Line 5118: FROM ozf_sd_request_lines_all

5114: requested_discount_currency,
5115: product_cost_currency,
5116: end_customer_currency,
5117: approved_discount_currency
5118: FROM ozf_sd_request_lines_all
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)