[Home] [Help]
100: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
101: --
102: CURSOR get_node_details_csr (p_csi_instance_id IN NUMBER) IS
103: SELECT M.concatenated_segments, C.serial_number
104: FROM csi_item_instances C,
105: mtl_system_items_kfv M
106: WHERE instance_id = p_csi_instance_id
107: AND M.inventory_item_id = C.inventory_item_id
108: AND M.organization_id = c.inv_master_organization_id;
138: l_csi_id NUMBER;
139: l_unit_csi_id NUMBER;
140: l_unit_name ahl_unit_config_headers.name%TYPE;
141: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE;
142: l_serial_number csi_item_instances.serial_number%TYPE;
143: --
144: BEGIN
145:
146: -- Standard call to check for call compatibility
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
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