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 3028: FROM oks_reprocessing_v rep, oe_order_headers oh

3024: CURSOR l_order_line_sub_csr
3025: IS
3026: SELECT ID, order_id, order_line_id, success_flag, source_flag,
3027: rep.order_number
3028: FROM oks_reprocessing_v rep, oe_order_headers oh
3029: WHERE success_flag = 'R'
3030: AND rep.order_id = oh.header_id
3031: AND conc_request_id IS NULL;
3032:

Line 3037: FROM oks_reprocessing_v rep, oe_order_headers oh

3033: CURSOR l_order_line_sel_csr
3034: IS
3035: SELECT ID, order_id, order_line_id, success_flag, source_flag,
3036: rep.order_number
3037: FROM oks_reprocessing_v rep, oe_order_headers oh
3038: WHERE reprocess_yn = 'Y' --success_flag IN ('R','N')
3039: AND rep.order_id = oh.header_id
3040: AND conc_request_id IS NULL;
3041:

Line 3046: FROM oks_reprocessing_v rep, oe_order_headers oh

3042: CURSOR l_order_line_all_csr
3043: IS
3044: SELECT ID, order_id, order_line_id, success_flag, source_flag,
3045: rep.order_number
3046: FROM oks_reprocessing_v rep, oe_order_headers oh
3047: WHERE NVL (success_flag, 'E') IN ('E', 'N') ---IN ('R','N','E')
3048: AND rep.order_id = oh.header_id
3049: AND conc_request_id IS NULL;
3050:

Line 4320: FROM oks_reprocessing_v

4316: IS
4317: CURSOR l_order_line_csr
4318: IS
4319: SELECT ID
4320: FROM oks_reprocessing_v
4321: WHERE success_flag = 'S';
4322:
4323: l_repv_tbl oks_rep_pvt.repv_tbl_type;
4324: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;