APPS.OKS_OCINT_PUB dependencies on OE_ORDER_HEADERS_ALL

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 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 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: