eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on CSI_ITEM_INSTANCES

Line 546: l_rm_inst_number csi_item_instances.instance_number%TYPE;

542: l_plan_id number;
543: l_wip_entity_id number;
544:
545: l_rm_inventory_item_id NUMBER;
546: l_rm_inst_number csi_item_instances.instance_number%TYPE;
547:
548: --To check if the unit config header is valid or not.
549: CURSOR ahl_uc_header_csr(p_uc_header_id number) IS
550: select 'x'

Line 594: from csi_item_instances cii

590: select cii.wip_job_id,
591: (select wip_entity_name
592: from wip_entities
593: where wip_entity_id = cii.wip_job_id) wip_job_name
594: from csi_item_instances cii
595: where cii.instance_id= l_item_instance_id
596: --and location_type_code NOT IN ('PO','IN-TRANSIT','PROJECT','INVENTORY')
597: and cii.location_type_code = 'WIP'
598: and trunc(sysdate) < trunc(nvl(cii.active_end_date, sysdate+1))

Line 604: from csi_item_instances

600:
601: -- to validate removal item instance.
602: CURSOR ahl_item_instance_csr(p_item_instance_id in number) IS
603: select inventory_item_id, instance_number
604: from csi_item_instances
605: where instance_id= p_item_instance_id
606: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
607:
608: -- To validate if instance's item defined in job's org.

Line 631: FROM csi_item_instances

627: quantity,
628: unit_of_measure,
629: inventory_revision,
630: serial_number
631: FROM csi_item_instances
632: WHERE instance_id = p_instance_id;
633:
634: l_config_instance_rec get_instance_attrib_csr%ROWTYPE;
635: l_new_instance_rec get_instance_attrib_csr%ROWTYPE;

Line 1102: from csi_item_instances

1098:
1099: --to get instance_id if instance_number is provided
1100: CURSOR ahl_instance_id_csr (p_instance_num in varchar2) IS
1101: select instance_id
1102: from csi_item_instances
1103: where instance_number= p_instance_num;
1104:
1105: /*
1106: --to get condition_id if condition meaning is provided

Line 1311: from csi_item_instances csi, csi_lookups f

1307:
1308: CURSOR ahl_location_type_csr(p_item_instance_id In number,
1309: p_csi_location_type In Varchar2) IS
1310: select location_type_code, f.meaning
1311: from csi_item_instances csi, csi_lookups f
1312: where csi.location_type_code = f.lookup_code
1313:
1314:
1315:

Line 1454: FROM mtl_system_items_b mtl, csi_item_instances csi

1450: l_msg_data varchar2(2000);
1451:
1452: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS
1453: SELECT 'X'
1454: FROM mtl_system_items_b mtl, csi_item_instances csi
1455: WHERE csi.instance_id = p_instance_id
1456: AND csi.inventory_item_id = mtl.inventory_item_id
1457: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
1458: AND mtl.serial_number_control_code = 1;

Line 1465: SELECT QUANTITY from csi_item_instances

1461: l_serialized VARCHAR2(1);
1462: l_move_item_instance_tbl move_item_instance_tbl_type;
1463:
1464: CURSOR get_curr_quantity_csr(p_instance_id IN NUMBER) IS
1465: SELECT QUANTITY from csi_item_instances
1466: WHERE INSTANCE_ID = p_instance_id;
1467:
1468: l_curr_config_qty NUMBER;
1469: l_curr_job_qty NUMBER;

Line 1477: from csi_item_instances CII

1473: l_instance_rec csi_datastructures_pub.instance_rec;
1474:
1475: CURSOR csi_item_instance_csr(p_instance_id IN NUMBER) IS
1476: select instance_number,object_Version_number
1477: from csi_item_instances CII
1478: where CII.instance_id = p_instance_id;
1479:
1480: CURSOR get_wip_job_csr(p_workorder_id IN NUMBER) IS
1481: select wip_entity_id from ahl_workorders

Line 1486: SELECT C1.instance_id FROM CSI_ITEM_INSTANCES C1, CSI_ITEM_INSTANCES C2

1482: where workorder_id = p_workorder_id;
1483: l_wip_job_id NUMBER;
1484:
1485: CURSOR removal_instance_id(p_instance_id IN NUMBER, p_wip_job_id IN NUMBER) IS
1486: SELECT C1.instance_id FROM CSI_ITEM_INSTANCES C1, CSI_ITEM_INSTANCES C2
1487: WHERE C1.INV_MASTER_ORGANIZATION_ID= C2.INV_MASTER_ORGANIZATION_ID
1488: AND C1.INVENTORY_ITEM_ID = C2.INVENTORY_ITEM_ID
1489: AND NVL(C1.INVENTORY_REVISION,'x') = NVL(C2.INVENTORY_REVISION,'x')
1490: AND NVL(C1.LOT_NUMBER,'x') = NVL(C2.LOT_NUMBER,'x')

Line 2084: FROM mtl_system_items_b mtl, csi_item_instances csi

2080: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2081:
2082: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS
2083: SELECT 'X'
2084: FROM mtl_system_items_b mtl, csi_item_instances csi
2085: WHERE csi.instance_id = p_instance_id
2086: AND csi.inventory_item_id = mtl.inventory_item_id
2087: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
2088: AND mtl.serial_number_control_code = 1;

Line 2095: SELECT QUANTITY from csi_item_instances

2091: l_serialized VARCHAR2(1);
2092: l_move_item_instance_tbl move_item_instance_tbl_type;
2093:
2094: CURSOR get_curr_quantity_csr(p_instance_id IN NUMBER) IS
2095: SELECT QUANTITY from csi_item_instances
2096: WHERE INSTANCE_ID = p_instance_id;
2097:
2098: l_curr_config_qty NUMBER;
2099: l_curr_job_qty NUMBER;

Line 2107: from csi_item_instances CII

2103:
2104:
2105: CURSOR csi_item_instance_csr(p_instance_id IN NUMBER) IS
2106: select instance_number,object_Version_number
2107: from csi_item_instances CII
2108: where CII.instance_id = p_instance_id;
2109:
2110: CURSOR get_wip_job_csr(p_workorder_id IN NUMBER) IS
2111: select wip_entity_id from ahl_workorders

Line 2116: SELECT C1.instance_id FROM CSI_ITEM_INSTANCES C1, CSI_ITEM_INSTANCES C2

2112: where workorder_id = p_workorder_id;
2113: l_wip_job_id NUMBER;
2114:
2115: CURSOR removal_instance_id(p_instance_id IN NUMBER, p_wip_job_id IN NUMBER) IS
2116: SELECT C1.instance_id FROM CSI_ITEM_INSTANCES C1, CSI_ITEM_INSTANCES C2
2117: WHERE C1.INV_MASTER_ORGANIZATION_ID= C2.INV_MASTER_ORGANIZATION_ID
2118: AND C1.INVENTORY_ITEM_ID = C2.INVENTORY_ITEM_ID
2119: AND NVL(C1.INVENTORY_REVISION,'x') = NVL(C2.INVENTORY_REVISION,'x')
2120: AND NVL(C1.LOT_NUMBER,'x') = NVL(C2.LOT_NUMBER,'x')

Line 2648: from csi_item_instances

2644:
2645: --For the updated object_version number from csi_item_isntances
2646: CURSOR ahl_obj_ver_csr(p_instance_id in Number) IS
2647: select object_Version_number
2648: from csi_item_instances
2649: where instance_id = p_instance_id;
2650:
2651: --to populate csi_transaction record
2652: CURSOR ahl_wip_location_csr IS

Line 2743: --FROM ahl_workorders_v AHL, csi_item_instances CSI

2739: CURSOR ahl_mtl_txn_param_csr (p_wo_id in number, p_instance_id number) is
2740: SELECT CSI.INVENTORY_ITEM_ID, AHL.organization_id
2741: , CSI.inventory_revision revision, CSI.quantity, CSI.unit_of_measure,
2742: CSI.serial_number, CSI.lot_number
2743: --FROM ahl_workorders_v AHL, csi_item_instances CSI
2744: FROM ahl_workorder_tasks_v AHL, csi_item_instances CSI
2745: Where CSI.instance_id = p_instance_id
2746: --and csi.inv_organization_id = ahl.organization_id
2747: And AHL.workorder_id = p_wo_id;

Line 2744: FROM ahl_workorder_tasks_v AHL, csi_item_instances CSI

2740: SELECT CSI.INVENTORY_ITEM_ID, AHL.organization_id
2741: , CSI.inventory_revision revision, CSI.quantity, CSI.unit_of_measure,
2742: CSI.serial_number, CSI.lot_number
2743: --FROM ahl_workorders_v AHL, csi_item_instances CSI
2744: FROM ahl_workorder_tasks_v AHL, csi_item_instances CSI
2745: Where CSI.instance_id = p_instance_id
2746: --and csi.inv_organization_id = ahl.organization_id
2747: And AHL.workorder_id = p_wo_id;
2748: BEGIN

Line 3089: FROM ahl_prd_dispositions_b disp, csi_item_instances csi,

3085: DISP.QUANTITY, DISP.UOM, disp.WO_OPERATION_ID, disp.item_revision revision,
3086: disp.serial_number, disp.lot_number,
3087: csi.inventory_item_id, vst.organization_id, vst.inv_locator_id,
3088: loc.subinventory_code, awo.operation_sequence_num
3089: FROM ahl_prd_dispositions_b disp, csi_item_instances csi,
3090: ahl_workorders wo, ahl_visits_b vst,
3091: mtl_item_locations_kfv loc, ahl_workorder_operations awo
3092: WHERE disp.instance_id = csi.instance_id
3093: AND disp.part_change_id = p_part_change_id

Line 3580: from csi_item_instances CII

3576:
3577: --For the updated object_version number from csi_item_isntances
3578: CURSOR csi_item_instance_id_csr(p_instance_id IN NUMBER) IS
3579: select instance_id,object_Version_number,serial_number,quantity,wip_job_id
3580: from csi_item_instances CII
3581: where CII.instance_id = p_instance_id
3582: AND CII.ACTIVE_START_DATE <= SYSDATE
3583: AND ((CII.ACTIVE_END_DATE IS NULL) OR (CII.ACTIVE_END_DATE > SYSDATE))
3584: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR

Line 3592: from csi_item_instances CII

3588: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)));
3589:
3590: CURSOR csi_item_instance_num_csr(p_instance_number IN VARCHAR2) IS
3591: select instance_id, object_Version_number,serial_number,quantity,wip_job_id
3592: from csi_item_instances CII
3593: where CII.instance_number = p_instance_number
3594: AND CII.ACTIVE_START_DATE <= SYSDATE
3595: AND ((CII.ACTIVE_END_DATE IS NULL) OR (CII.ACTIVE_END_DATE > SYSDATE))
3596: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR

Line 3614: FROM mtl_system_items_b mtl, csi_item_instances csi

3610:
3611:
3612: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS
3613: SELECT 'X'
3614: FROM mtl_system_items_b mtl, csi_item_instances csi
3615: WHERE csi.instance_id = p_instance_id
3616: AND csi.inventory_item_id = mtl.inventory_item_id
3617: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
3618: AND mtl.serial_number_control_code = 1;

Line 3920: FROM CSI_ITEM_INSTANCES CI1, CSI_ITEM_INSTANCES CI2

3916: l_instance_rec csi_datastructures_pub.instance_rec;
3917: --to find an expired instance if there
3918: /*CURSOR dest_instance_csr(p_source_instance_id IN NUMBER ) IS
3919: SELECT 'x'
3920: FROM CSI_ITEM_INSTANCES CI1, CSI_ITEM_INSTANCES CI2
3921: WHERE CI1.INV_MASTER_ORGANIZATION_ID= CI2.INV_MASTER_ORGANIZATION_ID
3922: AND CI1.INVENTORY_ITEM_ID = CI2.INVENTORY_ITEM_ID
3923: AND NVL(CI1.INVENTORY_REVISION,'x') = NVL(CI2.INVENTORY_REVISION,'x')
3924: AND NVL(CI1.LOT_NUMBER,'x') = NVL(CI2.LOT_NUMBER,'x')

Line 4058: FROM csi_item_instances

4054: inventory_revision,
4055: object_version_number,
4056: wip_job_id,
4057: location_id
4058: FROM csi_item_instances
4059: WHERE instance_id = p_instance_id;
4060:
4061: l_source_inst_rec get_instance_attrib_csr%ROWTYPE;
4062:

Line 4081: location_id FROM CSI_ITEM_INSTANCES CII

4077: install_date,
4078: inventory_revision,
4079: object_version_number,
4080: wip_job_id,
4081: location_id FROM CSI_ITEM_INSTANCES CII
4082: WHERE INV_MASTER_ORGANIZATION_ID= p_inv_master_org_id
4083: AND INVENTORY_ITEM_ID = p_inventory_item_id
4084: AND WIP_JOB_ID= p_wip_job_id
4085: AND instance_id <> p_source_instance_id

Line 4104: FROM CSI_ITEM_INSTANCES CI1, CSI_ITEM_INSTANCES CI2

4100: l_dest_instance_id NUMBER;
4101:
4102: CURSOR dest_inactive_instance_csr(p_source_instance_id IN NUMBER,p_wip_job_id IN NUMBER ) IS
4103: SELECT 'x'
4104: FROM CSI_ITEM_INSTANCES CI1, CSI_ITEM_INSTANCES CI2
4105: WHERE CI1.INV_MASTER_ORGANIZATION_ID= CI2.INV_MASTER_ORGANIZATION_ID
4106: AND CI1.INVENTORY_ITEM_ID = CI2.INVENTORY_ITEM_ID
4107: AND NVL(CI1.INVENTORY_REVISION,'x') = NVL(CI2.INVENTORY_REVISION,'x')
4108: AND NVL(CI1.LOT_NUMBER,'x') = NVL(CI2.LOT_NUMBER,'x')

Line 4466: FROM csi_item_instances

4462: INVENTORY_REVISION,
4463: LOT_NUMBER,
4464: LOCATION_ID,
4465: INSTANCE_STATUS_ID
4466: FROM csi_item_instances
4467: WHERE instance_id = p_instance_id;
4468:
4469: CURSOR dest_instance_csr(p_wip_job_id IN NUMBER,
4470: p_source_instance_id IN NUMBER ) IS

Line 4472: FROM CSI_ITEM_INSTANCES CI1, CSI_ITEM_INSTANCES CI2

4468:
4469: CURSOR dest_instance_csr(p_wip_job_id IN NUMBER,
4470: p_source_instance_id IN NUMBER ) IS
4471: SELECT CI1.instance_id
4472: FROM CSI_ITEM_INSTANCES CI1, CSI_ITEM_INSTANCES CI2
4473: WHERE CI1.INV_MASTER_ORGANIZATION_ID= CI2.INV_MASTER_ORGANIZATION_ID
4474: AND CI1.INVENTORY_ITEM_ID = CI2.INVENTORY_ITEM_ID
4475: AND NVL(CI1.INVENTORY_REVISION,'x') = NVL(CI2.INVENTORY_REVISION,'x')
4476: AND NVL(CI1.LOT_NUMBER,'x') = NVL(CI2.LOT_NUMBER,'x')

Line 4495: FROM CSI_ITEM_INSTANCES CI1, CSI_ITEM_INSTANCES CI2

4491:
4492: CURSOR dest_instance_csr1(p_wip_job_id IN NUMBER,
4493: p_source_instance_id IN NUMBER ) IS
4494: SELECT CI1.instance_id
4495: FROM CSI_ITEM_INSTANCES CI1, CSI_ITEM_INSTANCES CI2
4496: WHERE CI1.INV_MASTER_ORGANIZATION_ID= CI2.INV_MASTER_ORGANIZATION_ID
4497: AND CI1.INVENTORY_ITEM_ID = CI2.INVENTORY_ITEM_ID
4498: AND NVL(CI1.INVENTORY_REVISION,'x') = NVL(CI2.INVENTORY_REVISION,'x')
4499: AND NVL(CI1.LOT_NUMBER,'x') = NVL(CI2.LOT_NUMBER,'x')