[Home] [Help]
1623: csi.serial_number serial_number,
1624: mr.title mr_title
1625: FROM ahl_mr_headers_vl mr,
1626: mtl_system_items_kfv mtl,
1627: csi_item_instances csi
1628: WHERE mr.mr_header_id = c_mr_header_id
1629: AND csi.instance_id = c_item_instance_id
1630: AND csi.inventory_item_id = mtl.inventory_item_id
1631: AND csi.inv_master_organization_id = mtl.organization_id ;
1638: null mr_title
1639: FROM cs_incident_types_vl cit,
1640: cs_incidents_all_b cs,
1641: mtl_system_items_kfv mtl,
1642: csi_item_instances csi
1643: WHERE cs.incident_id = cs_incident_id
1644: AND cit.incident_type_id = cs.incident_type_id
1645: AND csi.instance_id = c_item_instance_id
1646: AND csi.inventory_item_id = mtl.inventory_item_id
3344: MTSB.CONCATENATED_SEGMENTS ITEM_NAME,
3345: CSIS.SERIAL_NUMBER SERIAL_NUMBER
3346: FROM ahl_visit_tasks_vl ATSK,
3347: MTL_SYSTEM_ITEMS_B_KFV MTSB,
3348: CSI_ITEM_INSTANCES CSIS
3349: WHERE visit_id = c_visit_id and
3350: ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+) and
3351: ATSK. INVENTORY_ITEM_ID = MTSB.INVENTORY_ITEM_ID(+) AND
3352: ATSK. ITEM_ORGANIZATION_ID = MTSB.ORGANIZATION_ID(+) AND
3506: csi.serial_number serial_number,
3507: mr.title mr_title
3508: FROM ahl_mr_headers_vl mr,
3509: mtl_system_items_kfv mtl,
3510: csi_item_instances csi
3511: WHERE mr.mr_header_id = c_mr_header_id
3512: AND csi.instance_id = c_item_instance_id
3513: AND csi.inventory_item_id = mtl.inventory_item_id
3514: AND csi.inv_master_organization_id = mtl.organization_id ;
3521: null mr_title
3522: FROM cs_incident_types_vl cit,
3523: cs_incidents_all_b cs,
3524: mtl_system_items_kfv mtl,
3525: csi_item_instances csi
3526: WHERE cs.incident_id = cs_incident_id
3527: AND cit.incident_type_id = cs.incident_type_id
3528: AND csi.instance_id = c_item_instance_id
3529: AND csi.inventory_item_id = mtl.inventory_item_id