113: BILLING_ITEM_ID,
114: ( SELECT DISTINCT CONCATENATED_SEGMENTS
115: FROM MTL_SYSTEM_ITEMS_KFV
116: WHERE INVENTORY_ITEM_ID=BILLING_ITEM_ID) BILLING_ITEM
117: from AHL_MR_HEADERS_APP_V
118: where mr_header_id=c_mr_header_id ;
119: l_mr_rec c_mr_csr%rowtype;
120:
121:
540: -- AnRaj: Changed query for fixing the prformance bug# 4919272
541: Cursor c_mr_csr(c_mr_id in number, c_org_id in number)
542: Is
543: SELECT mr.billing_item_id, mr.mr_header_id,mtls.primary_uom_code UOM_CODE
544: FROM AHL_MR_HEADERS_APP_V mr, mtl_system_items_b mtls
545: WHERE mr.mr_header_id = c_mr_id
546: AND mr.billing_item_id = mtls.inventory_item_id
547: AND mtls.organization_id = c_org_id
548: AND billing_item_id IS NOT NULL;
1250: From AHL_MR_HEADERS_V
1251: WHERE MR_HEADER_ID=C_MR_HEADER_ID;
1252: */
1253: SELECT 1
1254: From AHL_MR_HEADERS_APP_V
1255: WHERE MR_HEADER_ID=C_MR_HEADER_ID ;
1256:
1257: -- Cursor to get MR billing Item and UOM code
1258: -- AnRaj: Changed query for fixing the prformance bug# 4919272
1260: Is
1261: SELECT mr.billing_item_id,
1262: mr.mr_header_id,
1263: mtls.primary_uom_code UOM_CODE
1264: FROM AHL_MR_HEADERS_APP_V mr, mtl_system_items_b mtls
1265: WHERE mr.MR_HEADER_ID = C_MR_ID
1266: AND mr.BILLING_ITEM_ID = mtls.INVENTORY_ITEM_ID
1267: AND mtls.organization_id = c_org_id
1268: AND billing_item_id IS NOT NULL ;
2091: From ahl_mr_headers_v
2092: where mr_header_id=c_mr_id;
2093: */
2094: Select title, billing_item_id,description,mr_header_id
2095: From AHL_MR_HEADERS_APP_V
2096: where mr_header_id=c_mr_id;
2097:
2098: l_mr_rec c_mr_csr%rowtype;
2099: