DBA Data[Home] [Help]

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