APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on CSI_ITEM_INSTANCES

Line 443: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI, MTL_UNITS_OF_MEASURE UOM

439:
440: CURSOR get_part_info(c_instance_id NUMBER) IS
441: SELECT MTL.inventory_item_id, MTL.concatenated_segments, CSI.instance_number, CSI.serial_number, CSI.quantity,
442: CSI.lot_number, UOM.unit_of_measure, CSI.object_version_number
443: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI, MTL_UNITS_OF_MEASURE UOM
444: WHERE CSI.instance_id = c_instance_id
445: AND CSI.inventory_item_id = MTL.inventory_item_id
446: AND CSI.inv_master_organization_id = MTL.organization_id
447: AND CSI.unit_of_measure = UOM.uom_code;

Line 489: FROM CSI_ITEM_INSTANCES CI1,

485: OR disp.status_code NOT IN ('COMPLETE', 'TERMINATED'))
486: AND disp.primary_service_request_id = nr.SR_INCIDENT_ID(+)
487: AND disp.instance_id IN
488: (SELECT CI1.instance_id
489: FROM CSI_ITEM_INSTANCES CI1,
490: CSI_ITEM_INSTANCES CI2
491: WHERE CI1.INV_MASTER_ORGANIZATION_ID= CI2.INV_MASTER_ORGANIZATION_ID
492: AND CI1.INVENTORY_ITEM_ID = CI2.INVENTORY_ITEM_ID
493: AND NVL(CI1.INVENTORY_REVISION,'x') = NVL(CI2.INVENTORY_REVISION,'x')

Line 490: CSI_ITEM_INSTANCES CI2

486: AND disp.primary_service_request_id = nr.SR_INCIDENT_ID(+)
487: AND disp.instance_id IN
488: (SELECT CI1.instance_id
489: FROM CSI_ITEM_INSTANCES CI1,
490: CSI_ITEM_INSTANCES CI2
491: WHERE CI1.INV_MASTER_ORGANIZATION_ID= CI2.INV_MASTER_ORGANIZATION_ID
492: AND CI1.INVENTORY_ITEM_ID = CI2.INVENTORY_ITEM_ID
493: AND NVL(CI1.INVENTORY_REVISION,'x') = NVL(CI2.INVENTORY_REVISION,'x')
494: AND NVL(CI1.LOT_NUMBER,'x') = NVL(CI2.LOT_NUMBER,'x')

Line 532: FROM CSI_ITEM_INSTANCES CI1,

528: OR disp.status_code NOT IN ('COMPLETE', 'TERMINATED'))
529: AND disp.primary_service_request_id = nr.SR_INCIDENT_ID(+)
530: AND disp.instance_id IN
531: (SELECT CI1.instance_id
532: FROM CSI_ITEM_INSTANCES CI1,
533: CSI_ITEM_INSTANCES CI2
534: WHERE CI1.INV_MASTER_ORGANIZATION_ID= CI2.INV_MASTER_ORGANIZATION_ID
535: AND CI1.INVENTORY_ITEM_ID = CI2.INVENTORY_ITEM_ID
536: AND NVL(CI1.INVENTORY_REVISION,'x') = NVL(CI2.INVENTORY_REVISION,'x')

Line 533: CSI_ITEM_INSTANCES CI2

529: AND disp.primary_service_request_id = nr.SR_INCIDENT_ID(+)
530: AND disp.instance_id IN
531: (SELECT CI1.instance_id
532: FROM CSI_ITEM_INSTANCES CI1,
533: CSI_ITEM_INSTANCES CI2
534: WHERE CI1.INV_MASTER_ORGANIZATION_ID= CI2.INV_MASTER_ORGANIZATION_ID
535: AND CI1.INVENTORY_ITEM_ID = CI2.INVENTORY_ITEM_ID
536: AND NVL(CI1.INVENTORY_REVISION,'x') = NVL(CI2.INVENTORY_REVISION,'x')
537: AND NVL(CI1.LOT_NUMBER,'x') = NVL(CI2.LOT_NUMBER,'x')

Line 579: FROM CSI_ITEM_INSTANCES CSI

575: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);--Modified by Sunil
576:
577: CURSOR get_instance_number(c_instance_id NUMBER) IS
578: SELECT CSI.instance_number
579: FROM CSI_ITEM_INSTANCES CSI
580: WHERE CSI.instance_id = c_instance_id;
581:
582: -- Cursor to Know if position is controlled(container) position
583: CURSOR get_controled_position_csr(c_mc_header_id IN NUMBER,

Line 1413: CSI_ITEM_INSTANCES csi

1409: csi.unit_of_measure Inst_uom_code
1410:
1411: FROM AHL_MC_RELATIONSHIPS reln,
1412: AHL_ITEM_ASSOCIATIONS_B iasso,
1413: CSI_ITEM_INSTANCES csi
1414:
1415: WHERE reln.relationship_id = p_mc_relationship_id
1416: AND csi.instance_id = p_instance_id
1417: AND iasso.item_group_id = reln.item_group_id

Line 2156: select MTL.concatenated_segments,csi.serial_number from csi_item_instances csi, mtl_system_items_kfv MTL

2152:
2153: l_debug_key CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name;
2154:
2155: CURSOR item_info_csr(p_instance_number IN VARCHAR2) IS
2156: select MTL.concatenated_segments,csi.serial_number from csi_item_instances csi, mtl_system_items_kfv MTL
2157: where csi.instance_number like p_instance_number
2158: and csi.inventory_item_id = MTL.inventory_item_id
2159: and CSI.INV_MASTER_ORGANIZATION_ID = MTL.ORGANIZATION_ID;
2160: