APPS.AHL_MC_RULE_ENGINE_PVT dependencies on CSI_II_RELATIONSHIPS

Line 425: FROM csi_ii_relationships csi_ii

421: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 04-Dec-2007
422: -- Relationship start date check should include SYSDATE too.
423: CURSOR get_csi_ids_csr (p_csi_instance_id IN NUMBER) IS
424: SELECT csi_ii.subject_id
425: FROM csi_ii_relationships csi_ii
426: START WITH csi_ii.object_id = p_csi_instance_id
427: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
428: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate-1)) <= TRUNC(sysdate)
429: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 458: FROM csi_ii_relationships csi_ii

454: WHERE uch.master_config_id = p_mc_header_id
455: AND uch.csi_item_instance_id = p_csi_instance_id
456: UNION ALL
457: SELECT csi_ii.object_id
458: FROM csi_ii_relationships csi_ii
459: WHERE csi_ii.object_id IN
460: (SELECT csi_item_instance_id
461: FROM ahl_unit_config_headers
462: --mpothuku added '='

Line 490: FROM csi_ii_relationships

486: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 04-Dec-2007
487: -- Cursor to fetch the parent instance id for a given instance id.
488: CURSOR get_parent_instance_csr(p_csi_instance_id IN NUMBER) IS
489: SELECT object_id
490: FROM csi_ii_relationships
491: WHERE subject_id = p_csi_instance_id
492: AND TRUNC(nvl(ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
493: AND TRUNC(nvl(ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);
494:

Line 861: FROM csi_ii_relationships csi_ii,

857:
858: -- Cursor to get the distinct UOM count of all the non-extra children of an instance.
859: CURSOR check_child_inst_uoms_csr(p_csi_instance_id IN NUMBER) IS
860: SELECT count(distinct unit_of_measure)
861: FROM csi_ii_relationships csi_ii,
862: csi_item_instances csi
863: WHERE csi_ii.object_id = p_csi_instance_id
864: AND csi_ii.subject_id = csi.instance_id
865: AND csi_ii.position_reference is not null

Line 873: FROM csi_ii_relationships csi_ii,

869:
870: -- Cursor to get the sum of quantities of all the non-extra children of an instance.
871: CURSOR get_tot_child_quant_csr(p_csi_instance_id IN NUMBER) IS
872: SELECT nvl(sum(quantity),0) quantity
873: FROM csi_ii_relationships csi_ii,
874: csi_item_instances csi
875: WHERE csi_ii.object_id = p_csi_instance_id
876: AND csi_ii.subject_id = csi.instance_id
877: AND csi_ii.position_reference is not null