901: FROM oe_order_lines l,
902: mtl_system_items m
903: WHERE l.line_id = p_x_line_rec.service_reference_line_id
904: AND l.inventory_item_id = m.inventory_item_id
905: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
906:
907: -- Bug 9001060
908: EXCEPTION
909: WHEN No_Data_Found THEN
960: FROM oe_order_lines l,
961: mtl_system_items m
962: WHERE l.line_id = p_x_line_rec.service_reference_line_id
963: AND l.inventory_item_id = m.inventory_item_id
964: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
965: END IF;
966: END IF;
967:
968: IF l_debug_level > 0 THEN
1265: FROM csi_instance_accts_rg_v
1266: WHERE customer_product_id = :b1 AND account_id = :b2 AND rownum < 2 ';
1267: */
1268: begin
1269: l_query_type := nvl(OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG_SVC'),'N'); --7120799
1270: exception
1271: when others then
1272: l_query_type := 'N';
1273: end;
1683: FROM oe_order_lines l,
1684: mtl_system_items m
1685: WHERE l.line_id = p_line_rec.service_reference_line_id
1686: AND l.inventory_item_id = m.inventory_item_id
1687: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
1688:
1689: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1690: -- Then Call it Else Not
1691: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
2394: Using p_reference_line_id, p_customer_id;
2395: x_cust_product_line_id := l_order_line_id;
2396: */
2397: begin
2398: l_query_type := nvl(OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG_SVC'),'N'); --7120799
2399: exception
2400: when others then
2401: l_query_type := 'N';
2402: end;