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

3067: CURSOR get_order_lines_csr (p_ord_num NUMBER)
3068: IS
3069: SELECT ol.line_id, NVL (fulfilled_quantity, 0),
3070: service_reference_type_code, service_reference_line_id
3071: FROM oe_order_lines_all ol, oe_order_headers oh
3072: WHERE oh.header_id = ol.header_id
3073: AND oh.order_number = p_ord_num;
3074:
3075: --and Oh.org_id = okc_context.get_okc_org_id;

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

3079: Is
3080: Select Nvl(FULFILLED_QUANTITY,0),SERVICE_REFERENCE_TYPE_CODE,SERVICE_REFERENCE_LINE_ID
3081: From oe_order_lines_all
3082: Where line_id = p_ord_line_id
3083: and header_id IN (select header_id from oe_order_headers_all where org_id = okc_context.get_okc_org_id);
3084: */
3085:
3086: --mmadhavi modified the cursor for MOAC
3087: CURSOR check_duplicate_csr (p_ordline_id NUMBER)

Line 3090: FROM oks_reprocessing rep, oe_order_headers hdr

3086: --mmadhavi modified the cursor for MOAC
3087: CURSOR check_duplicate_csr (p_ordline_id NUMBER)
3088: IS
3089: SELECT 'x'
3090: FROM oks_reprocessing rep, oe_order_headers hdr
3091: WHERE rep.order_line_id = p_ordline_id
3092: AND rep.order_id = hdr.header_id;
3093:
3094: l_ord_line_id NUMBER;

Line 4492: FROM oe_order_lines_all ol, oe_order_headers_all oh

4488:
4489: CURSOR l_order_hdr_csr (p_ordlineid NUMBER)
4490: IS
4491: SELECT oh.header_id, oh.order_number
4492: FROM oe_order_lines_all ol, oe_order_headers_all oh
4493: WHERE ol.line_id = (p_ordlineid)
4494: AND oh.org_id = okc_context.get_okc_org_id
4495: AND oh.header_id = ol.header_id;
4496: