APPS.AHL_MC_ITEMGROUP_PVT dependencies on CSI_ITEM_INSTANCES

Line 794: FROM csi_ii_relationships reln, csi_item_instances csi

790: CURSOR get_item_instances_csr(p_position_reference IN VARCHAR2,
791: p_inventory_item_id IN NUMBER,
792: p_inventory_org_id IN NUMBER) IS
793: SELECT instance_id csi_item_instance_id
794: FROM csi_ii_relationships reln, csi_item_instances csi
795: WHERE reln.subject_id = csi.instance_id
796: AND TRUNC(SYSDATE) < TRUNC(NVL(reln.active_end_date, SYSDATE+1))
797: AND reln.relationship_type_code = 'COMPONENT-OF'
798: AND reln.position_reference = p_position_reference

Line 809: FROM ahl_unit_config_headers unit, csi_item_instances csi

805: p_inventory_org_id IN NUMBER) IS
806: SELECT 'x'
807: FROM DUAL
808: WHERE EXISTS (SELECT name
809: FROM ahl_unit_config_headers unit, csi_item_instances csi
810: WHERE unit.csi_item_instance_id = csi.instance_id
811: AND master_config_id = p_relationship_id
812: AND TRUNC(SYSDATE) < TRUNC(NVL(unit.active_end_date, SYSDATE+1))
813: AND csi.inventory_item_id = p_inventory_item_id