APPS.OKS_OCINT_PUB dependencies on OKS_REPROCESSING_V

Line 536: FROM oks_reprocessing_v

532: IS
533: CURSOR l_old_repv_csr (p_id NUMBER)
534: IS
535: SELECT object_version_number
536: FROM oks_reprocessing_v
537: WHERE ID = p_id;
538:
539: --l_old_repv_rec l_old_repv_csr%ROWTYPE;
540: l_obj_vers_num NUMBER;

Line 2384: FROM oks_reprocessing_v rep, oe_order_headers oh

2380: CURSOR l_order_line_sub_csr
2381: IS
2382: SELECT ID, order_id, order_line_id, success_flag, source_flag,
2383: rep.order_number
2384: FROM oks_reprocessing_v rep, oe_order_headers oh
2385: WHERE success_flag = 'R'
2386: AND rep.order_id = oh.header_id
2387: AND conc_request_id IS NULL;
2388:

Line 2393: FROM oks_reprocessing_v rep, oe_order_headers oh

2389: CURSOR l_order_line_sel_csr
2390: IS
2391: SELECT ID, order_id, order_line_id, success_flag, source_flag,
2392: rep.order_number
2393: FROM oks_reprocessing_v rep, oe_order_headers oh
2394: WHERE reprocess_yn = 'Y' --success_flag IN ('R','N')
2395: AND rep.order_id = oh.header_id
2396: AND conc_request_id IS NULL;
2397:

Line 2402: FROM oks_reprocessing_v rep, oe_order_headers oh

2398: CURSOR l_order_line_all_csr
2399: IS
2400: SELECT ID, order_id, order_line_id, success_flag, source_flag,
2401: rep.order_number
2402: FROM oks_reprocessing_v rep, oe_order_headers oh
2403: WHERE NVL (success_flag, 'E') IN ('E', 'N') ---IN ('R','N','E')
2404: AND rep.order_id = oh.header_id
2405: AND conc_request_id IS NULL;
2406:

Line 3676: FROM oks_reprocessing_v

3672: IS
3673: CURSOR l_order_line_csr
3674: IS
3675: SELECT ID
3676: FROM oks_reprocessing_v
3677: WHERE success_flag = 'S';
3678:
3679: l_repv_tbl oks_rep_pvt.repv_tbl_type;
3680: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;