APPS.OKS_OCINT_PUB dependencies on OE_ORDER_LINES

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 172: FROM oe_order_lines_all

168: IS
169: SELECT comms_nl_trackable_flag
170: FROM mtl_system_items_b
171: WHERE inventory_item_id = (SELECT inventory_item_id
172: FROM oe_order_lines_all
173: WHERE line_id = l_ref_order_line_id)
174: AND organization_id = l_organization_id
175: AND serviceable_product_flag = 'Y' ; /*BUG6181908 -- FP Bug#6006309*/
176:

Line 809: oe_order_lines_all ol,

805: IS
806: SELECT csi.install_date, ol.actual_shipment_date,
807: mtl.service_starting_delay
808: FROM csi_item_instances csi,
809: oe_order_lines_all ol,
810: okx_system_items_v mtl
811: WHERE csi.instance_id = p_cp_id
812: AND csi.last_oe_order_line_id = ol.line_id
813: AND csi.inventory_item_id = mtl.id1

Line 825: FROM oe_order_lines --mmadhavi for MOAC

821:
822: CURSOR l_inv_csr (p_ordline_id NUMBER)
823: IS
824: SELECT inventory_item_id
825: FROM oe_order_lines --mmadhavi for MOAC
826: WHERE line_id = p_ordline_id;
827:
828: CURSOR l_lndates_csr (p_id NUMBER)
829: IS

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 2437: From oe_order_lines_all

2433: /*
2434: Cursor get_ordlines_dtls_csr(p_ord_line_id NUMBER)
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:

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:

Line 3876: FROM oe_order_lines_all

3872: IS
3873: SELECT comms_nl_trackable_flag
3874: FROM mtl_system_items_b
3875: WHERE inventory_item_id = (SELECT inventory_item_id
3876: FROM oe_order_lines_all
3877: WHERE line_id = l_ref_order_line_id)
3878: AND organization_id = l_organization_id;
3879:
3880: l_order_rec l_order_csr%ROWTYPE;