[Home] [Help]
895: FROM oe_order_lines l,
896: mtl_system_items m
897: WHERE l.line_id = p_x_line_rec.service_reference_line_id
898: AND l.inventory_item_id = m.inventory_item_id
899: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
900:
901: --Added for Bug # 4770432 Try to get blanket No from Top Model
902: --if unable to get from currently referenced option item
903: IF l_blanket_number is NULL AND l_top_model_id is NOT NULL THEN
946: FROM oe_order_lines l,
947: mtl_system_items m
948: WHERE l.line_id = p_x_line_rec.service_reference_line_id
949: AND l.inventory_item_id = m.inventory_item_id
950: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
951: END IF;
952: END IF;
953:
954: IF l_debug_level > 0 THEN
1247: FROM csi_instance_accts_rg_v
1248: WHERE customer_product_id = :b1 AND account_id = :b2 AND rownum < 2 ';
1249: */
1250: begin
1251: l_query_type := nvl(OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG_SVC'),'N'); --7120799
1252: exception
1253: when others then
1254: l_query_type := 'N';
1255: end;
1652: FROM oe_order_lines l,
1653: mtl_system_items m
1654: WHERE l.line_id = p_line_rec.service_reference_line_id
1655: AND l.inventory_item_id = m.inventory_item_id
1656: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
1657:
1658: -- IF OKS_OMINT_PUB.IS_SERVICE_AVAILABLE exists in DB
1659: -- Then Call it Else Not
1660: /* OE_SERVICE_UTIL.CHECK_PROC('OKS_OMINT_PUB.IS_SERVICE_AVAILABLE', l_return_status);
2354: Using p_reference_line_id, p_customer_id;
2355: x_cust_product_line_id := l_order_line_id;
2356: */
2357: begin
2358: l_query_type := nvl(OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG_SVC'),'N'); --7120799
2359: exception
2360: when others then
2361: l_query_type := 'N';
2362: end;