APPS.OKS_OCINT_PUB dependencies on OE_ORDER_HEADERS

Line 144: FROM oe_order_lines_all ol, oe_order_headers_all oh

140:
141: CURSOR l_order_hdr_csr (p_ordlineid NUMBER)
142: IS
143: SELECT oh.header_id, oh.order_number
144: FROM oe_order_lines_all ol, oe_order_headers_all oh
145: WHERE ol.line_id = (p_ordlineid)
146: AND oh.org_id = okc_context.get_okc_org_id
147: AND oh.header_id = ol.header_id;
148:

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 2427: FROM oe_order_lines_all ol, oe_order_headers oh

2423: CURSOR get_order_lines_csr (p_ord_num NUMBER)
2424: IS
2425: SELECT ol.line_id, NVL (fulfilled_quantity, 0),
2426: service_reference_type_code, service_reference_line_id
2427: FROM oe_order_lines_all ol, oe_order_headers oh
2428: WHERE oh.header_id = ol.header_id
2429: AND oh.order_number = p_ord_num;
2430:
2431: --and Oh.org_id = okc_context.get_okc_org_id;

Line 2439: and header_id IN (select header_id from oe_order_headers_all where org_id = okc_context.get_okc_org_id);

2435: Is
2436: Select Nvl(FULFILLED_QUANTITY,0),SERVICE_REFERENCE_TYPE_CODE,SERVICE_REFERENCE_LINE_ID
2437: From oe_order_lines_all
2438: Where line_id = p_ord_line_id
2439: and header_id IN (select header_id from oe_order_headers_all where org_id = okc_context.get_okc_org_id);
2440: */
2441:
2442: --mmadhavi modified the cursor for MOAC
2443: CURSOR check_duplicate_csr (p_ordline_id NUMBER)

Line 2446: FROM oks_reprocessing rep, oe_order_headers hdr

2442: --mmadhavi modified the cursor for MOAC
2443: CURSOR check_duplicate_csr (p_ordline_id NUMBER)
2444: IS
2445: SELECT 'x'
2446: FROM oks_reprocessing rep, oe_order_headers hdr
2447: WHERE rep.order_line_id = p_ordline_id
2448: AND rep.order_id = hdr.header_id;
2449:
2450: l_ord_line_id NUMBER;

Line 3848: FROM oe_order_lines_all ol, oe_order_headers_all oh

3844:
3845: CURSOR l_order_hdr_csr (p_ordlineid NUMBER)
3846: IS
3847: SELECT oh.header_id, oh.order_number
3848: FROM oe_order_lines_all ol, oe_order_headers_all oh
3849: WHERE ol.line_id = (p_ordlineid)
3850: AND oh.org_id = okc_context.get_okc_org_id
3851: AND oh.header_id = ol.header_id;
3852: