APPS.AHL_UC_UNITCONFIG_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 326: ahl_mc_relationships R

322: CURSOR get_rec_from_value(c_mc_name varchar2, c_mc_revision varchar2) IS
323: SELECT H.mc_header_id,
324: R.relationship_id
325: FROM ahl_mc_headers_b H,
326: ahl_mc_relationships R
327: WHERE H.name = c_mc_name
328: AND H.revision = c_mc_revision
329: AND H.mc_header_id = R.mc_header_id
330: AND R.parent_relationship_id IS NULL

Line 337: ahl_mc_relationships R

333: CURSOR get_rec_from_id(c_mc_header_id NUMBER ) IS
334: SELECT H.mc_header_id,
335: R.relationship_id
336: FROM ahl_mc_headers_b H,
337: ahl_mc_relationships R
338: WHERE H.mc_header_id = c_mc_header_id
339: AND H.mc_header_id = R.mc_header_id
340: AND R.parent_relationship_id IS NULL
341: AND trunc(nvl(R.active_start_date,SYSDATE)) <= trunc(SYSDATE)

Line 405: ahl_mc_relationships R,

401: c_relationship_id NUMBER) IS
402: --Added DISTINCT to the following two queries for fixing bug 4102152, Jerry on 01/04/2005
403: SELECT distinct C.instance_id
404: FROM csi_item_instances C,
405: ahl_mc_relationships R,
406: ahl_item_associations_b A
407: WHERE C.instance_number = c_instance_num
408: AND R.relationship_id = c_relationship_id
409: AND R.item_group_id = A.item_group_id

Line 437: ahl_mc_relationships R,

433: AND trunc(nvl(H.active_end_date, SYSDATE+1)) > trunc(SYSDATE));
434: CURSOR get_rec_from_id(c_instance_id NUMBER, c_relationship_id NUMBER) IS
435: SELECT distinct C.instance_id
436: FROM csi_item_instances C,
437: ahl_mc_relationships R,
438: ahl_item_associations_b A
439: WHERE C.instance_id = c_instance_id
440: AND R.relationship_id = c_relationship_id
441: AND R.item_group_id = A.item_group_id