[Home] [Help]
108: -- ONC.quantity on_quantity,
109: PC.installed_quantity on_quantity,
110: ONC.unit_of_measure on_uom
111: FROM ahl_part_changes_v PC,
112: csi_item_instances OFFC,
113: mtl_system_items_kfv OFFI,
114: csi_item_instances ONC,
115: mtl_system_items_kfv ONI
116: WHERE PC.part_change_id = c_part_change_id
110: ONC.unit_of_measure on_uom
111: FROM ahl_part_changes_v PC,
112: csi_item_instances OFFC,
113: mtl_system_items_kfv OFFI,
114: csi_item_instances ONC,
115: mtl_system_items_kfv ONI
116: WHERE PC.part_change_id = c_part_change_id
117: AND PC.removed_instance_id = OFFC.instance_id (+)
118: AND PC.installed_instance_id = ONC.instance_id (+)
794: --Check if position is empty or filled
795: CURSOR check_installed_csr (p_parent_id IN NUMBER,
796: p_relationship_id IN NUMBER) IS
797: SELECT csi.instance_id
798: FROM csi_item_instances csi, csi_ii_relationships rel
799: WHERE csi.instance_id = rel.subject_id
800: AND REL.object_id = p_parent_id
801: AND REL.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
802: AND TRUNC(nvl(REL.ACTIVE_START_DATE, sysdate-1)) <= TRUNC(sysdate)
903: FROM AHL_PRD_DISPOSITIONS_b disp,
904: AHL_PRD_DISPOSITIONS_tl displ,
905: AHL_MC_PATH_POSITIONS pp,
906: MTL_SYSTEM_ITEMS_KFV MTL,
907: CSI_ITEM_INSTANCES CSI,
908: AHL_ITEM_GROUPS_B GRP,
909: MTL_MATERIAL_STATUSES_TL COND,
910: CS_INCIDENTS_ALL_B INC,
911: CS_INCIDENTS_ALL_TL INCL,
1053: CS_INCIDENTS_ALL_TL INCL,
1054: CS_INCIDENT_SEVERITIES_TL SEV,
1055: FND_LOOKUP_VALUES PCODE,
1056: MTL_SYSTEM_ITEMS_KFV MTL,
1057: CSI_ITEM_INSTANCES CSI,
1058: AHL_ITEM_GROUPS_B GRP,
1059: MTL_MATERIAL_STATUSES_TL COND,
1060: FND_LOOKUP_VALUES FND1,
1061: FND_LOOKUP_VALUES FND2,
1202: FND_LOOKUP_VALUES FND3,
1203: MTL_MATERIAL_STATUSES_TL COND,
1204: AHL_ITEM_GROUPS_B GRP,
1205: MTL_SYSTEM_ITEMS_KFV MTL,
1206: CSI_ITEM_INSTANCES CSI,
1207: CS_INCIDENTS_ALL_B INC,
1208: CS_INCIDENTS_ALL_TL INCL,
1209: CS_INCIDENT_SEVERITIES_TL SEV,
1210: FND_LOOKUP_VALUES PCODE,