APPS.AHL_UC_POS_NECES_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 492: FROM ahl_unit_config_headers uc, ahl_mc_relationships mc

488:
489: --Get the relationship id if instance is a uc header
490: CURSOR get_relnship_id_csr(c_csi_instance_id IN NUMBER) IS
491: SELECT mc.relationship_id
492: FROM ahl_unit_config_headers uc, ahl_mc_relationships mc
493: WHERE uc.master_config_id = mc.mc_header_id
494: AND mc.parent_relationship_id is null
495: AND uc.csi_item_instance_id = c_csi_instance_id
496: AND trunc(nvl(uc.active_start_date,sysdate)) <= trunc(sysdate)

Line 514: FROM ahl_mc_relationships mc

510: --Check mandatory children
511: CURSOR check_mand_child_missing_csr(c_relationship_id IN NUMBER,
512: c_parent_instance_id IN NUMBER) IS
513: SELECT 'X'
514: FROM ahl_mc_relationships mc
515: WHERE mc.parent_relationship_id = c_relationship_id
516: AND mc.position_necessity_code = 'MANDATORY'
517: AND trunc(nvl(mc.active_start_date,sysdate)) <= trunc(sysdate)
518: AND trunc(sysdate) < trunc(nvl(mc.active_end_date, sysdate+1))

Line 709: FROM ahl_unit_config_headers uc, ahl_mc_relationships mc

705:
706: --Get the relationship id if instance is a uc header
707: CURSOR get_relnship_id_csr(c_csi_instance_id IN NUMBER) IS
708: SELECT mc.relationship_id
709: FROM ahl_unit_config_headers uc, ahl_mc_relationships mc
710: WHERE uc.master_config_id = mc.mc_header_id
711: AND mc.parent_relationship_id is null
712: AND uc.csi_item_instance_id = c_csi_instance_id
713: AND trunc(nvl(uc.active_start_date,sysdate)) <= trunc(sysdate)

Line 731: FROM ahl_mc_relationships mc

727: --Check mandatory children
728: CURSOR check_mand_child_missing_csr(c_relationship_id IN NUMBER,
729: c_parent_instance_id IN NUMBER) IS
730: SELECT mc.relationship_id, mc.position_ref_code
731: FROM ahl_mc_relationships mc
732: WHERE mc.parent_relationship_id = c_relationship_id
733: AND mc.position_necessity_code = 'MANDATORY'
734: AND trunc(nvl(mc.active_start_date,sysdate)) <= trunc(sysdate)
735: AND trunc(sysdate) < trunc(nvl(mc.active_end_date, sysdate+1))

Line 748: FROM ahl_mc_relationships

744: --
745: --Get mandatory children for missing position
746: CURSOR get_mand_pos_desc_csr(c_relationship_id IN NUMBER) IS
747: SELECT position_ref_code
748: FROM ahl_mc_relationships
749: START WITH parent_relationship_id = c_relationship_id
750: AND trunc(nvl(active_start_date,sysdate-1)) <= trunc(sysdate)
751: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
752: CONNECT BY PRIOR relationship_id = parent_relationship_id

Line 1210: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso, csi_item_instances csi

1206: where subject_id = c_instance_id
1207: and relationship_type_code = 'COMPONENT-OF'
1208: and trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1209: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))) parent_instance_id
1210: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso, csi_item_instances csi
1211: WHERE csi.INSTANCE_ID = c_instance_id
1212: AND reln.relationship_id = c_mc_relationship_id
1213: AND iasso.item_group_id = reln.item_group_id
1214: AND iasso.inventory_item_id = CSI.INVENTORY_ITEM_ID

Line 1545: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso, csi_item_instances csi

1541: where subject_id = c_instance_id
1542: and relationship_type_code = 'COMPONENT-OF'
1543: and trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1544: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))) parent_instance_id
1545: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso, csi_item_instances csi
1546: WHERE csi.INSTANCE_ID = c_instance_id
1547: AND reln.relationship_id = c_mc_relationship_id
1548: AND iasso.item_group_id = reln.item_group_id
1549: AND iasso.inventory_item_id = CSI.INVENTORY_ITEM_ID